DATEVALUE

Tries to convert a any value into a date

Syntax

Summary: Return date serial number from given text.
Syntax: DATEVALUE( Text D )
Returns: Date
Constraints: None
Semantics: This computes the date of the text string D, using the current locale. This function accepts ISO date format (YYYY-MM-DD), which is locale-independent. If the text of D has a combined date and time format, e.g. YYYY-MM-DD HH:MM:SS, the integer part of the date serial number is returned. If the text of D represents a number, the number is treated as serial date number (days since 1.1.1900) and is converted into a date.

Examples