FORMAT_DATETIME_WITH_TIMEZONE
Format datetime into human-readable text, using an explicit timezone

Description

Returns the given datetime formatted into a human readable text.
The formatted text takes the given timezone into account, adjusting the output accordingly.

Function signature

1
FORMAT_DATETIME_WITH_TIMEZONE(date: String, format: String, timezone: String) => String
Copied!
Parameter
Description
Date
Date
Format
Format to display date
Timezone
Timezone in which the date will be formatted. Defaults to the timezone defined in the date/time itself, or UTC if undefined.

Examples

Formula
Return value
FORMAT_DATETIME_WITH_TIMEZONE("2019-07-11T13:06:15+03:00", "DD-MM-YYYY HH:mm:ss")
11-07-2019 13:06:15
FORMAT_DATETIME_WITH_TIMEZONE("2019-07-11T13:06:15Z", "DD-MM-YYYY HH:mm:ss", "Europe/Helsinki")
11-07-2019 16:06:15
Export as PDF
Copy link