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

 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
=DATE([BYear];[BMonth];[BDay])

June 21, 1969

  • No labels