DateTimeToTimeZone

Mon 01 January 2018

Syntax

DateTimeToTimeZone(OldDateTime, SourceTimeZone, DestinationTimeZone)

Description

Use the DateTimeToTimeZone function to convert DateTime values from the DateTime specified by SourceTimeZone to the DateTime specified by DestinationTimeZone .

Parameters

Field or Control

Definition

OldDateTime

Specify the DateTime value to be converted.

SourceTimeZone

Specify the time zone that OldDateTime is in. Valid values are:

  • timezone - a time zone abbreviation or a field reference to be used for converting OldDateTime .

  • Local - use the local time zone for converting OldDateTime .

  • Base - use the base time zone for converting OldDateTime .

DestinationTimeZone

Specify the time zone that you want to convert OldDateTime to. Valid values are:

  • timezone - a time zone abbreviation or a field reference to be used for converting OldDateTime .

  • Local - use the local time zone for converting OldDateTime .

  • Base - use the base time zone for converting OldDateTime .

Returns

A converted DateTime value.