userdate() Function

Function

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()

Parameters

Keyword Type Description

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

Usage considerations

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

Open in Github Built: Fri, Sep 17, 2021 (04:05:09 PM)

On This Page

FEEDBACK