userdate( year, month, day )
Identifies the date represented by year, month, and day and then interprets it in the user preferred calendar, converting it into a serial number.
See also: datetext()
Keyword | Type | Description |
---|---|---|
|
Number |
The year of the date you would like to convert into a serial number. |
|
Number |
The number of the month of the date. |
|
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