Format_datetime_with_timezone
- 18 May 2022
- 1 Minute to read
-
DarkLight
-
PDF
Format_datetime_with_timezone
- Updated on 18 May 2022
- 1 Minute to read
-
DarkLight
-
PDF
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
FORMAT_DATETIME_WITH_TIMEZONE(date: String, format: String, timezone: String) => String
| 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 |
Was this article helpful?