peoplecodeapi - TimeZoneOffset

Syntax

TimeZoneOffset(DateTime {[, timezone | "Base" | "Local"]})

Description

Use the TimeZoneOffset function to generate a time offset for datetime . The offset represents the relative time difference to GMT. If no other parameters are specified with datetime , the server's base time zone is used.

Parameters

Field or Control	Definition
`datetime`	Specify the DateTime value to be used for generating the offset.
`timezone` \| Local \| Base	Specify a value to be used with `datetime` . The values are: `timezone -` a time zone abbreviation or a field reference to be used with `datetime` . Local - use the local time zone with `datetime.` Base - use the base time zone with `datetime` .

Field or Control

Definition

datetime

Specify the DateTime value to be used for generating the offset.

timezone | Local | Base

Specify a value to be used with datetime . The values are:

timezone - a time zone abbreviation or a field reference to be used with datetime .

Local - use the local time zone with datetime.

Base - use the base time zone with datetime .

Returns

An offset string of the following format:

Shh:mm

where

Field or Control	Definition
S	is + or -, with + meaning East of Greenwich
hh	is the hours of offset
mm	is the minutes of offset