DATEVALUE Function
Function Type | Predefined function | ||
Syntax | DATEVALUE( <dateString> ) | ||
Description | Converts a character string representation of a date into a date value. <dateString> - Formatted date string to be converted into a real date value. The DATEVALUE function understands dates in the following formats. The results are calculated assuming the current year is 1994. | ||
Format | Example | Result (yyyymmdd) | |
mm-dd-yyyy | 07-12-1994 | 19940712 | |
mm-dd-yy | 12-03-94 | 19941203 | |
mm-dd | 11-25 | 19941125 | |
mm/dd/yyyy | 01/01/1955 | 19550101 | |
mm/dd/yy | 09/23/47 | 19470923 | |
mm/dd | 08/03 | 19940803 | |
dd-mon-yyyy | 12-Jun-1983 | 19830612 | |
dd-mon-yy | 15-Mar-01 | 19940315 | |
dd-mon | 30-Sep | 19940930 | |
dd-month-yyyy | 31-October-2315 | 23151031 | |
dd-month-yy | 10-August-58 | 19580810 | |
dd-month | 01-April | 19940401 | |
Returns | Date | ||
Example | This example converts a formatted date in a literal string to a date value. DATEVALUE("01/01/1955") |