userdate() Function

Identifies the date represented by year, month, and day and then interprets it in the user preferred calendar, converting it into a serial number.

Syntax

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.

Returns

Date

Notes

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.

Examples

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

See Also

datetext()

17.1

On This Page

FEEDBACK