FORMAT_DATETIME_LOCAL
Format datetime into human-readable text, with local timezone taken into account

Description

Returns the given DateTime formatted into a human readable text. Follows the latest Moment.js syntax.
The formatted text takes the current timezone of the device into account, so e.g. a date returned by a server in UTC +0 is formatted correctly to take the local time difference into account.

Function signature

1
FORMAT_DATETIME_LOCAL(date/time: String, format: String) => String
Copied!
Parameter
Description
Date/time
Date/time to format
Format
Format in which the date/time is returned

Examples

Formula
Return value
FORMAT_DATETIME_LOCAL("2019-07-11T13:06:15+03:00", "DD.MM.YYYY HH:mm:ss")
11.07.2019 05:06:15
FORMAT_DATETIME_LOCAL("2019-02-11T13:06:15Z", "DD.MM.YYYY HH:mm:ss")
11.02.2019 07:06:15
FORMAT_DATETIME_LOCAL("2022-01-13T07:30:15+03:00", "DD.MM HH:mm")
13.01 06:30
Export as PDF
Copy link