GetAsNumber
Purpose 
Returns only the numbers in text, as field type number, for use with formulas involving numbers or numeric functions.
Format 
GetAsNumber(text)
Parameters 
text - any text expression or text field containing numbers
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
This function drops all non-numeric characters from text.
You can also use this function to convert a date to the number of days. The returned number is the number of days since 1/1/0001.
Examples 
GetAsNumber(“FY98”) returns 98.
GetAsNumber(“$1,254.50”) returns 1254.5.
GetAsNumber(“2 + 2”) returns 22.
GetAsNumber(SerialNumber) returns 35684, when the value of SerialNumber is TKV35FRG6HH84.
GetAsNumber(DateOfBirth) returns 735516, when the DateOfBirth field contains 10/10/2014.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.