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

Function

gmt( datetime, timezone )

Subtracts a time zone offset from a 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 subtract from the datetime parameter.

Returns

Date and Time

Usage considerations

This function does not store a 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

gmt(datetime(2011, 2, 07, 16, 05),"America/New_York") returns 2/7/2011 9:05 PM GMT+00:00

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
Open in Github Built: Thu, Mar 28, 2024 (10:34:21 PM)

gmt() Function

FEEDBACK