CONVERTTIMEZONE Function

From Planfix
Jump to: navigation, search

The function converts a date and time from one time zone to another. For example, this is useful when you receive a date in UTC and need to know the client's local time.

Format

CONVERTTIMEZONE(Date and time; Source time zone; Target time zone) where:

  • time zone names are from the IANA list.

Examples

CONVERTTIMEZONE("2025-06-13 15:00"; "UTC"; "America/New_York")

CONVERTTIMEZONE("2025-06-13 15:00"; "America/New_York"; "America/Los_Angeles")


Go To