FORMAT_DATE
Last updated
Was this helpful?
Last updated
Was this helpful?
FORMAT_DATE
formats a given date, from either an information or a text in , 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:
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
This returns 28.02.2022
.
This returns 02-28-2022
.