Functions Reference

GetAsDate
Format
GetAsDate(text)
Parameter
text - any text expression or text field containing text in the same format as the date on
the system where the file was created.
Data type returned
date
Description
Returns dates in text as data type date, for use in formulas involving dates or date
functions. The format of text date must be the same as the date format on the system
where the file was created.
Use the GetAsDate or Date function to enter a date constant into a formula.
If the function returns a number instead of a date, go to the Specify Calculation dialog
box and make sure the Calculation result is date.
To avoid errors when using dates, always use four-digit years. For more
information about how FileMaker Pro handles two-digit dates, see FileMaker Pro help.
Example
GetAsDate(“03/03/2005”) returns 3/3/2005. You can perform date operations on
this result.
GetAsNumber
Format
GetAsNumber(text)
Parameter
text - any text expression
or text field containing numbers
Data type returned
number
Description
Returns only the numbers in text, as data type number, for use with formulas involving
numbers or numeric functions. The GetAsNumber function drops all non-numeric
characters from text.