FunctionCopy link to clipboard
value( text, separator )
Converts text representing a number into an actual number or datetime.
ParametersCopy link to clipboard
| Keyword | Type | Description |
|---|---|---|
|
|
Text |
The string of characters to be converted into a number or date. |
|
|
Text |
A string separating different values in the text. For instance, |
ReturnsCopy link to clipboard
Any Type
Usage considerationsCopy link to clipboard
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.
ExamplesCopy link to clipboard
value("12/13/2005","mm/dd/yyyy") returns 12/13/05 12:00 AM GMT
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 | 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 | |
| Process Autoscaling | Compatible |