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

Function

local( datetime, timezone )

This is a Date and Time addition function, adding time zone offset to given Date and Time.

Parameters

Keyword Type Description

datetime

Date and Time

The base Date and Time to be modified.

timezone

Number(Integer)

The time zone offset to add to the datetime parameter.

Returns

Date and Time

Usage considerations

This function does not store the time zone offset with the returned value.

The datetime parameter accepts Date variables, Date and Time variables, and process properties such as pp!starttime.

The timezone parameter accepts inputs as time zone IDs, time zone acronyms, hours and minutes offset from a Datetime stored in GMT such as "GMT-6:00", or in minutes offset -30. If this parameter is not passed, the default behavior is to evaluate the time zone for the current time zone context.

Passing a time zone ID (such as America/New_York) causes the result to be adjusted for daylight saving time. Passing a time zone acronym (such as "GMT") does not cause the result to be adjusted for daylight savings time. Time zones must be enclosed in quotation marks <">. Colons <:> and plus characters <+> are not accepted, unless the parameter is enclosed in quotation marks.

Examples

local(datetime(2011, 2, 07, 16, 05), "America/New_York") returns 2/7/2011 11:05 AM

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

local() Function

FEEDBACK