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


value( text, separator )

Converts text representing a number into an actual number or datetime.


Keyword Type Description



The string of characters to be converted into a number or date.



A string separating different values in the text. For instance, value("1,2,3",",") would return {1,2,3}.


Any Type

Usage considerations

The text value checks for decimal points, slashes, hyphens, and colons to determine whether you are trying to have the function return a date or a number.


value("12/13/2005","mm/dd/yyyy") returns 12/13/05 12:00 AM GMT

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 Incompatible
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

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 Compatible
Process Events Compatible

value() Function