Converts a value to text.
Formats a date according to Excel's syntax. Allowed format characters are:
yy two digit year
yyyy four digit year
m month as one or two digits
mm month as two digits
mmm for the short name of the month ("Jan")
mmmm for the long name of the month ("January")
d day of the month as one or two digits
dd day of the month as two digits
ddd day of the week, short form ("Wed")
dddd day of the week, long form ("Wednesday")
hh for hours.
mm* for minutes
AM/PM for the string "AM" or "PM"
A/P for "A" or "P"
The meaning of
m is contextual: if it comes after an
h or immediately before an
s , it means "minutes."
If one of
A/P is specified, hours are displayed in the 12-hour format; otherwise they are displayed in the 24-hour format.
Any characters that are not listed above are reproduced verbatim in the output string, most commonly
/ , or
TEXT(DATETIME("2019-11-01"), "dd/mm/yyyy") returns
TEXT(DATETIME("2019-11-01 1:34 PM"), "HH:MM") returns