Identifies the date represented by year, month, and day and then interprets it in the user preferred calendar, converting it into a serial number.
userdate( year, month, day )
year: (Number) The year of the date you would like to convert into a serial number.
month: (Number) The number of the month of the date.
day: (Number) The day of the date.
Date
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(userdate(1427,8,18),mm/dd/yyyy)
returns 8/18/1427