Syntax
YEAR (year ; month ; day)
year (required) - An integer between 1583 and 9956, or 0 - 99.
month (required) - An integer between 1 and 12 representing month.
day (required) - An integer between 1 and 31 representing day of month.
Examples
Hard Code values:
|| Syntax || Result || | report: DATE(1969 ; 6 ; 21) | June 21, 1969 | | report: DATE(1 ; 6 ; 21 ) | June 21, 2001 |
report: DATE(1 ; 6 ; 21 )
Returns June 21, 2001.
Variable/Fields values:
BYear = 1969
BMonth = 6
BDay = 21
report: DATE([BYear];[BMonth];[BDay])
Returns June 21, 1969.