userdate() Function
This function may not be compatible with all features of Appian. For details, see the Feature Compatibility section below.

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

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Partially compatible

Can be used with Appian Portals if it is connected using an integration and web API.

Offline Mobile Partially compatible

Can be used with offline mobile if it is loaded at the top of the form.

Custom Record Field Expressions Incompatible
Open in Github Built: Fri, Aug 12, 2022 (10:01:45 AM)

On This Page

FEEDBACK