value() Function
This function may not be compatible with all features of Appian. For details, see the Feature Compatibility section below.

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

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
Custom Record Field Expressions Compatible
Open in Github Built: Wed, Aug 10, 2022 (11:20:24 PM)

On This Page

FEEDBACK