Hitachi Vantara Pentaho Community Wiki


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.


Syntax Result
=DateValue("1996/12/25") Dec 25, 1996
BDate = "2006/11/1" (string)
Nov 1, 2006
=DateValue(1) Jan 1, 1900
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.