GetAsDate()
Category: Text
|
Syntax: GetAsDate ( text ) |
Parameters:
textAny text expression or text field that returns a date, formatted the same as the date format on the system where the file was created.
Data type returned: Date
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.
Note: In order to avoid errors, we recommend always using four-digit years; however, GetAsDate ( "1/1" ) will resolve to 1/1/2006 assuming the current year is 2006. GetAsDate ( "1/1/05" ) will resolve to 1/1/0005.
Examples:
|
Function |
Results |
|---|---|
|
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. |