QUE CORPORATION - Using Filemaker pro X

GetAsDate()

Category: Text

Syntax: GetAsDate ( text )

Parameters: text ”any text expression or text field that returns a date, formatted the same as the date format on the system where the file was created.

Description:

GetAsDate() interprets a text string that contains a date as an actual date. Anytime you use a date constant within a calculation formula, you should use the GetAsDate() or Date() functions to ensure that the date is interpreted correctly.

Examples:

GetAsDate ("1/1/2004")

Returns 1/1/2004 stored internally as a date.

GetAsDate ("1/1/2004") + 8

Returns 1/9/2004 . In this case, had the GetAsDate() function not been used, "1/1/2004" + 8 would have returned 112012 .