< Day Day Up > |
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 . |
< Day Day Up > |