Hitachi Vantara Pentaho Community Wiki
Child pages
Skip to end of metadata
Go to start of metadata

Tries to convert a any value into a date


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.





Dec 25, 1996

BDate = "2006/11/1" (string)

Nov 1, 2006


Jan 1, 1900

  • No labels