FORMAT_DATE
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 |
FORMAT_DATE('2022-02-28', 'DD.MM.YYYY')
This returns
28.02.2022
.FORMAT_DATE('2022-02-28', 'MM-DD-YYYY')
This returns
02-28-2022
.Last modified 1yr ago