value() Function
This function cannot be used with Offline Mobile.
For a full list of functions and their feature compatibility, explore the Appian Functions table.

Function

value( text, format )

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.

format

Text

The input format of the value, such as "mm/dd/yyyy".

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

You can experiment with this function in the test box below.

Test Input

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

Open in Github Built: Wed, Jan 26, 2022 (11:43:23 AM)

On This Page

FEEDBACK