timezoneabbreviation(
TIMEZONE
,
DATE
)

The timezoneabbreviation( function returns the abbreviation of the specified time zone.


Parameters

This function has two parameters:

timezone – geographic area of the time zone. This parameter is optional – if omitted, the local time zone will be used (the local time zone can also be specified as local).

date – allows you to specify a date into the future. This parameter is optional – if omitted, today’s date will be used. Some time zones change abbreviation depending on the date, for example EST/EDT.


Description

This function returns the abbreviation of the specified time zone. For example, in California in the winter, this formula will return PST (Pacific Standard Time).

timezoneabbreviation() ☞ PST

You can specify a different times zone (see converttimezone( for detailed information about specifying a time zone).

timezoneabbreviation("Denver") ☞ MST

Some time zones have a different abbreviation at different times of the year. You can optionally find out the abbreviation for a specific date, like this:

timezoneabbreviation("Denver",date("July 12") ☞ MDT

See Also


History

VersionStatusNotes
10.2NewNew in this version