ParseDate

ParseDate(x)

Parses a textual date into a numeric value indicating the number of days elapsed since Analytica's date origin. When the "Use Excel date origin" preference is not set, the origin is 1 Jan 1904, and when set it is 1 Jan 1900. The integer value returned displays as a date when a date number format is used to display the result.

Example

ParseDate("1 Aug 2007") → 37833
ParseDate("8/1/2007") → 37833

(These examples assumes English-language regional settings and that the "Use Excel date origin" preference is off.)

Notes

ParseDate is useful when parsing data read in from textual files.

There are other ways of entering and parsing dates. You can enter dates directly into definitions or edit table cells when the variable's number format is set to Date. This is generally how dates are entered in models, rather than through the use of ParseDate.

(TO DO) Discuss impact of regional settings on the behavior of date parsing.

See Also

• ParseNum
• Preferences (see "Use Excel date origin")
• ReadTextFile, ReadCsvFile
• MakeDate