FORMAT_DATE

Description
FORMAT_DATE formats a given date, from either an information or a text in ISO8601 format, into the specified format. There might be two documents that ask for a different date format, e.g. 28.02.2022 vs. 02-28-2022. The given format can contain the following options:
Option
Description
D
Days without leading zero, e.g. 7 or 13
DD
Days with leading zero, e.g. 07 or 13
M
Months without leading zero, e.g. 2 or 11
MM
Months with leading zero, e.g. 02 or 11
YYYY
The year, e.g. 1987 or 2021
​
Example: German Format
FORMAT_DATE('2022-02-28', 'DD.MM.YYYY')
This returns 28.02.2022.
Example: US Format
FORMAT_DATE('2022-02-28', 'MM-DD-YYYY')
This returns 02-28-2022.

Option	Description
`D`	Days without leading zero, e.g. 7 or 13
`DD`	Days with leading zero, e.g. 07 or 13
`M`	Months without leading zero, e.g. 2 or 11
`MM`	Months with leading zero, e.g. 02 or 11
`YYYY`	The year, e.g. 1987 or 2021

TODAY

DAYS

Last modified 1yr ago