FunctionCopy link to clipboard
userdatevalue( date_text )
Interprets the given date in the user preferred calendar and converts it into an equivalent serial number.
See also: datetext()
ParametersCopy link to clipboard
Keyword | Type | Description |
---|---|---|
|
Text |
The date to be converted into a serial number. |
ReturnsCopy link to clipboard
Date
Usage considerationsCopy link to clipboard
To display the date, always wrap the output with datetext()
.
Using this function in a process model with autoscale enabled may result in degraded site or application performance. It should be used with caution and tested thoroughly before deploying it for real-world use. When the application is in production, use the Autoscaled Process Activity tab to monitor how the process performs at scale.
ExamplesCopy link to clipboard
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 compatibilityCopy link to clipboard
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. |
Process Autoscaling | Partially compatible | Using this function in a process model with autoscale enabled may result in degraded site or application performance. |