Hitachi Vantara Pentaho Community Wiki
Child pages
  • DATEVALUE

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

Syntax

Result

=DateValue("1996/12/25")

Dec 25, 1996

BDate = "2006/11/1" (string)
 
<ac:structured-macro ac:name ="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="96776e33-5bb9-469e-abed-eaa8058077cd"><ac:plain-text-body><![CDATA[=DateValue([BDate])

Nov 1, 2006

]]></ac:plain-text-body></ac:structured-macro>

=DateValue(1)

Jan 1, 1900