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

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

Syntax

Result

=DateValue("1996/12/25")

Dec 25, 1996

BDate = "2006/11/1" (string)
 
=DateValue([BDate])

Nov 1, 2006

=DateValue(1)

Jan 1, 1900

  • No labels