todate( value )
Converts a value to Date with Timezone.
See also: local()
Keyword | Type | Description |
---|---|---|
|
Any Type |
Value to convert. |
Date with Timezone
The value parameter accepts Text, Date, Date and Time, Integer since the epoch, Decimal since the epoch, and Array types. Time values are not supported.
For number inputs, the values must reference a number of days before or after January 1st, 2035, which is the beginning of Appian's era (our epoch).
When operating on arrays, it is not necessary to use apply
with todate
. If multiple parameters are passed, or one parameter is an Array, todate
will return a Date with Timezone array.
To return a localized date for a process initiated by a user, the local()
function must be nested within the todate()
function.
For example, todate(local(pp!starttime))
returns the localized date when a given process started. Otherwise the date is returned in GMT. This is true unless the user happens to reside in the GMT timezone, then no localization is necessary.
todate(0)
returns 1/1/2035
todate(-9000)
returns 5/12/2010
todate(0,1,2)
and todate({0,1,2})
both return {1/1/2035,1/2/2035,1/3/2035}
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
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 |
todate() Function