DATEVALUE(S)

 

Description

This function returns the datetime value corresponding to a given string S.  It interprets the data in the following forms:

 

DD.MM.YY

 

In all forms, the year can be omitted; in that case, it defaults to the current year.  The year can be provided as two or four digits.  A two-year digit assumes the 20th century.  In the above formats, the month (MMM) is not case-sensitive and can be either the standard three-letter abbreviation or the full name of the month.

 

Refer to DATE for more information on datetime values.

 

Parameters

 

S

The string value of a date.

 

Examples

 

DATEVALUE("3/24/1954") = 19807

 

DATEVALUE("3/24/54") = 19807

 

DATEVALUE("4-July-1994") = 34519

 

DATEVALUE("4-July") = 34519

Where the year is omitted, and assuming the year is 1994.

 

DATEVALUE("September-94") = 34578

 

DATEVALUE("Sep-1994") = 34578

 

DATEVALUE("SEP") = 34578

Where the year is omitted, and assuming the year is 1994.

 

DATEVALUE("06.04.66") = 24203

 

DATEVALUE("06.04.1966") = 24203