TimeZoneOffset function

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

Parameter	Description
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

Parameter	Description
S	is + or -, with + meaning East of Greenwich
hh	is the hours of offset
mm	is the minutes of offset