Skip to main content
Planview Customer Success Center

ToTimeZone Function

ToTimeZone (dateTime as DateTime, fromTimeZone as ObjectIdentifier, toTimeZone as ObjectIdentifier) as DateTime

Category: Date
Description: Converts the given date time parameter from the 'from' timezone to the 'to' time zone
Supported Context: FormulaField And BusinessRules
Parameters:  
dateTime as DateTime Represents a date time value or reference to a field that will return a date time
fromTimeZone as ObjectIdentifier(Time Zone)

Represents the current time zone of the value indicated in the "dateTime" parameter, or reference to a field that returns a time zone. Accepts a time zone code which can be accessed from within the "pick list" tab of the formula helper (i.e. 'Greenwich Standard Time')

  • Afghanistan Standard Time
  • Alaskan Standard Time
  • Arab Standard Time
  • Arabian Standard Time
  • Arabic Standard Time
  • Argentina Standard Time
  • Atlantic Standard Time
  • AUS Central Standard Time
  • AUS Eastern Standard Time
  • Azerbaijan Standard Time
  • Azores Standard Time
  • Canada Central Standard Time
  • Cape Verde Standard Time
  • Caucasus Standard Time
  • Cen. Australia Standard Time
  • Central America Standard Time
  • Central Asia Standard Time
  • Central Brazilian Standard Time
  • Central Europe Standard Time
  • Central European Standard Time
  • Central Pacific Standard Time
  • Central Standard Time
  • Central Standard Time (Mexico)
  • China Standard Time
  • Dateline Standard Time
  • E. Africa Standard Time
  • E. Australia Standard Time
  • E. Europe Standard Time
  • E. South America Standard Time
  • Eastern Standard Time
  • Egypt Standard Time
  • Ekaterinburg Standard Time
  • Fiji Standard Time
  • FLE Standard Time
  • Georgian Standard Time
  • GMT Standard Time
  • Greenland Standard Time
  • Greenwich Standard Time
  • GTB Standard Time
  • Hawaiian Standard Time
  • India Standard Time
  • Iran Standard Time
  • Israel Standard Time
  • Jordan Standard Time
  • Kamchatka Standard Time
  • Korea Standard Time
  • Mauritius Standard Time
  • Mid-Atlantic Standard Time
  • Middle East Standard Time
  • Montevideo Standard Time
  • Morocco Standard Time
  • Mountain Standard Time
  • Mountain Standard Time (Mexico)
  • Myanmar Standard Time
  • N. Central Asia Standard Time
  • Namibia Standard Time
  • Nepal Standard Time
  • New Zealand Standard Time
  • Newfoundland Standard Time
  • North Asia East Standard Time
  • North Asia Standard Time
  • Pacific SA Standard Time
  • Pacific Standard Time
  • Pacific Standard Time (Mexico)
  • Pakistan Standard Time
  • Paraguay Standard Time
  • Romance Standard Time
  • Russian Standard Time
  • SA Eastern Standard Time
  • SA Pacific Standard Time
  • SA Western Standard Time
  • Samoa Standard Time
  • SE Asia Standard Time
  • Singapore Standard Time
  • South Africa Standard Time
  • Sri Lanka Standard Time
  • Taipei Standard Time
  • Tasmania Standard Time
  • Tokyo Standard Time
  • Tonga Standard Time
  • Ulaanbaatar Standard Time
  • US Eastern Standard Time
  • US Mountain Standard Time
  • UTC
  • Venezuela Standard Time
  • Vladivostok Standard Time
  • W. Australia Standard Time
  • W. Central Africa Standard Time
  • W. Europe Standard Time
  • West Asia Standard Time
  • West Pacific Standard Time
  • Yakutsk Standard Time
toTimeZone as ObjectIdentifier(Time Zone)

Represents the time zone to which you would like to convert the value indicated in the "dateTime" parameter, or reference to a field that returns a time zone. Accepts a time zone code which can be accessed from within the "pick list" tab of the formula helper (i.e. 'Greenwich Standard Time')

  • Afghanistan Standard Time
  • Alaskan Standard Time
  • Arab Standard Time
  • Arabian Standard Time
  • Arabic Standard Time
  • Argentina Standard Time
  • Atlantic Standard Time
  • AUS Central Standard Time
  • AUS Eastern Standard Time
  • Azerbaijan Standard Time
  • Azores Standard Time
  • Canada Central Standard Time
  • Cape Verde Standard Time
  • Caucasus Standard Time
  • Cen. Australia Standard Time
  • Central America Standard Time
  • Central Asia Standard Time
  • Central Brazilian Standard Time
  • Central Europe Standard Time
  • Central European Standard Time
  • Central Pacific Standard Time
  • Central Standard Time
  • Central Standard Time (Mexico)
  • China Standard Time
  • Dateline Standard Time
  • E. Africa Standard Time
  • E. Australia Standard Time
  • E. Europe Standard Time
  • E. South America Standard Time
  • Eastern Standard Time
  • Egypt Standard Time
  • Ekaterinburg Standard Time
  • Fiji Standard Time
  • FLE Standard Time
  • Georgian Standard Time
  • GMT Standard Time
  • Greenland Standard Time
  • Greenwich Standard Time
  • GTB Standard Time
  • Hawaiian Standard Time
  • India Standard Time
  • Iran Standard Time
  • Israel Standard Time
  • Jordan Standard Time
  • Kamchatka Standard Time
  • Korea Standard Time
  • Mauritius Standard Time
  • Mid-Atlantic Standard Time
  • Middle East Standard Time
  • Montevideo Standard Time
  • Morocco Standard Time
  • Mountain Standard Time
  • Mountain Standard Time (Mexico)
  • Myanmar Standard Time
  • N. Central Asia Standard Time
  • Namibia Standard Time
  • Nepal Standard Time
  • New Zealand Standard Time
  • Newfoundland Standard Time
  • North Asia East Standard Time
  • North Asia Standard Time
  • Pacific SA Standard Time
  • Pacific Standard Time
  • Pacific Standard Time (Mexico)
  • Pakistan Standard Time
  • Paraguay Standard Time
  • Romance Standard Time
  • Russian Standard Time
  • SA Eastern Standard Time
  • SA Pacific Standard Time
  • SA Western Standard Time
  • Samoa Standard Time
  • SE Asia Standard Time
  • Singapore Standard Time
  • South Africa Standard Time
  • Sri Lanka Standard Time
  • Taipei Standard Time
  • Tasmania Standard Time
  • Tokyo Standard Time
  • Tonga Standard Time
  • Ulaanbaatar Standard Time
  • US Eastern Standard Time
  • US Mountain Standard Time
  • UTC
  • Venezuela Standard Time
  • Vladivostok Standard Time
  • W. Australia Standard Time
  • W. Central Africa Standard Time
  • W. Europe Standard Time
  • West Asia Standard Time
  • West Pacific Standard Time
  • Yakutsk Standard Time
Returned value as DateTime Returns a date time value equal to the date time entered in the "dateTime" parameter converted to the time zone indicated in the "toTimeZone" parameter
Example #1

Convert current time to the current user's time zone

ToTimeZone(Now(), 'UTC', GetTimeZone(CurrentUser()))

Tips This function has a parameter from type pick list that may have being customized by your organization. Please refer to the pick list values in the formula helper editor or view the values within the relevant field.