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. |