|
Category
String Functions
Description
Convert a string to a date value
Syntax
ToDate(string)
Parameters
string - a literal string or string function result that can be parsed as a date
Notes
The following date formats can be parsed by this function:
•yyyymmdd (as a string)
•mm/dd/yy or mm/dd/yyyy, where mm and dd are either 1 or 2 digits
•dd-mmm-yy or dd-mmm-yyyy, where mmm is Jan, Feb, etc. (not case-sensitive)
If the string is not a valid date, the result will be 0.
|
