GetAsDate
Purpose 
Returns dates in text as field type date, for use in formulas involving dates or date functions.
Format 
GetAsDate(text)
Parameters 
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 
Use the GetAsDate or Date function to enter a date constant into a formula. The format of text date must be the same as the date format on the system where the file was created.
Note  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.
Important  To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Conversion of dates with two-digit years.
Examples 
GetAsDate(“03/03/2010”) returns 3/3/2010. You can perform date operations on this result.
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.