Free cookie consent management tool by TermsFeed userdatevalue() Function
userdatevalue() Function


userdatevalue( date_text )

Interprets the given date in the user preferred calendar and converts it into an equivalent serial number.

See also: datetext()


Keyword Type Description



The date to be converted into a serial number.



Usage considerations

To display the date, always wrap the output with datetext().


You can copy and paste these examples into the Expression Rule Designer to see how this works.

datetext(userdatevalue("8/18/1427"),"yyyy/MM/dd") returns 1427/8/18`

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.

Sync-Time Custom Record Fields Incompatible
Real-Time Custom Record Fields Incompatible

Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.

Process Reports Incompatible

Cannot be used to configure a process report.

Process Events Incompatible

Cannot be used to configure a process event node, such as a start event or timer event.

userdatevalue() Function