Interprets the given date and time in the user preferred calendar and converts it into a serial number.
userdatetime( year, month, day, [hour], [minute], [second] )
year: (Number) The year of the datetime you would like to convert into a serial number.
month: (Number) The number of the month of the datetime.
day: (Number) The day of the datetime.
hour: (Number) The hour of the datetime.
minute: (Number) The minute of the datetime.
second: (Number) The seconds of the datetime.
To display the date, always wrap the output with
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.
08/18/1427 01:02 AM
On This Page