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')
|
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')
|
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. |