Date Formats

Some Date Functions have a Format parameter that can be used to format the date. The format types you can use are listed below. Insert the Format specifier in the formula.

E.g. format(@Deadline, "dd-MM-yyyy") => "01-06-2017"

Format specifier Description
"d" The day of the month, from 1 through 31.
"dd" The day of the month, from 01 through 31.
"ddd" The abbreviated name of the day of the week.
"dddd" The full name of the day of the week. e.g. Monday
"g", "gg" The period or era. e.g. A.D.
"h" The hour, using a 12-hour clock from 1 to 12.
"hh" The hour, using a 12-hour clock from 01 to 12.
"H" The hour, using a 24-hour clock from 0 to 23.
"HH" The hour, using a 24-hour clock from 00 to 23.
"m" The minute, from 0 through 59.
"mm" The minute, from 00 through 59.
"M" The month, from 1 through 12.
"MM" The month, from 01 through 12.
"MMM" The abbreviated name of the month. e.g. Feb
"MMMM" The full name of the month. e.g. February
"tt" The AM/PM designator.
"y" The year, from 0 to 99. e.g. 4
"yy" The year, from 00 to 99. e.g. 04
"yyy" The year, with a minimum of three digits.
"yyyy" The year as a four-digit number.
"yyyyy" The year as a five-digit number.
Any other character The character is copied to the result text unchanged.
What would you improve in this article?