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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

 Construct date from year, month, and day of month.

Syntax

Syntax: DATE( Integer Year ; Integer Month ; Integer Day )
Returns: Date
Constraints: 1 <= Month <= 12; 1 <= Day <= 31

Semantics: This computes the date's serial number given Year, Month, and Day. Fractional values are truncated.

year (required) - An integer representing the year.
month (required) - An integer between 1 and 12 representing month.
day (required) - An integer between 1 and 31 representing day of month. 

Examples

Syntax

Result

=DATE(1969 ; 6 ; 21)

June 21, 1969

=DATE(1 ; 6 ; 21 )

June 21, 1 AD

BYear = 1969
BMonth = 6
BDay = 21
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c02a092d-11e1-4614-bd96-a7ac07e644b0"><ac:plain-text-body><![CDATA[=DATE([BYear];[BMonth];[BDay])

June 21, 1969

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

  • No labels