userdatetime( year, month, day, hour, minute, second )
Interprets the given date and time in the user preferred calendar and converts it into a serial number.
See also: datetext()
Keyword | Type | Description |
---|---|---|
|
Number |
The year of the datetime you would like to convert into a serial number. |
|
Number |
The number of the month of the datetime. |
|
Number |
The day of the datetime. |
|
Number |
The hour of the datetime. |
|
Number |
The minute of the datetime. |
|
Number |
The seconds of the datetime. |
DateTime
To display the date, always wrap the output with datetext()
.
For the month parameter, do not include leading zeroes for a month with one digit.
You can copy and paste these examples into the Expression Rule Designer to see how this works.
datetext(userdatetime(1427,8,18,1,2,0))
returns 08/18/1427 01:02 AM