Function

value( text, separator )

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

Parameters

Keyword	Type	Description
text	Text	The string of characters to be converted into a number or date.
separator	Text	A string separating different values in the text. For instance, value("1,2,3",",") would return {1,2,3}.

Returns

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.

Examples

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