date |
|
Manual -> Report Generator -> Engineering in the Editor -> Report functions -> Date and time functions -> date |
   Show
all  Hide
all |
date |
|
Manual -> Report Generator -> Engineering in the Editor -> Report functions -> Date and time functions -> date |
|
Show
all Hide
all |
The function date (iYear, iMonth, iDay) calculates the date from the numerical values for year (iYear), month (iMonth) and day (iDay).
Syntax: =date(iYear,iMonth,iDay)
|
Transfer parameters |
Valid range |
Comment |
|---|---|---|
|
iYear |
[0100-2200] |
|
|
iMonth |
[1-12] |
Values out of the valid range are set to the upper or lower limit |
|
iDay |
[1-(28,29,30,31)] |
Values out of the valid range are set to the upper or lower limit |
Result format: date
Standard format: dd/mm/yyyy
|
|
|
=date(2001,5,12) is 12.05.2001 Cell A1=2001, cell A2=5, cell A3=12 |
Example