Free cookie consent management tool by TermsFeed datevalue() Function
datevalue() Function


datevalue( value )

Converts a value to a date.


Keyword Type Description


Any Type

Value to convert.


Date with Timezone

Usage considerations

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.

When operating on arrays, it is not necessary to use apply with datevalue. If multiple parameters are passed, or one parameter is an Array, datevalue will return a Date with Timezone array.

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).

To return a localized date for a process initiated by a user, the local() function must be nested within the datevalue() function.

For example, datevalue(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.


datevalue(0) returns 1/1/2035

datevalue(-9000) returns 5/12/2010

datevalue(0,1,2) and datevalue({0,1,2}) both return {1/1/2035,1/2/2035,1/3/2035}

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
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

datevalue() Function