Custom Date and Time Format
Custom date and time format in autonumber field
| Format specifier | Description |
|---|---|
| d | The day of the month, from 1 to 31. |
| dd | The day of the month, from 01 to 31. |
| ddd | The abbreviated name of the day of the week. |
| dddd | The full name of the day of the week. |
| 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 to 59. |
| mm | The minute, from 00 to 59. |
| M | The month, from 1 to 12. |
| MM | The month, from 01 to 12. |
| MMM | The abbreviated name of the month. |
| MMMM | The full name of the month. |
| s | The second, from 0 to 59. |
| ss | The second, from 00 to 59. |
| tt | The AM/PM designator. |
| y | The year, from 0 to 99. |
| yy | The year, from 00 to 99. |
| 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. |
Custom date format in date field
| Format specifier | Display | |
|---|---|---|
| Year | YY | 70 71 ... 29 30 (last two digits of the year) |
| YYYY | 1970 1971 ... 2029 2030 | |
| Month | M | 1 2 ... 11 12 |
| MM | 01 02 ... 11 12 | |
| MMM | Jan Feb ... Nov Dec | |
| MMMM | January Febrary ... November December | |
| Days in a month | D | 1 2 ... 30 31 |
| DD | 01 02 ... 30 31 | |
| Days in a year | DDD | 1 2 ... 364 365 |
| DDDD | 001 002 ... 364 365 | |
| Days in a week | d | 0 1 ... 5 6 |
| ddd | Sun Mon ... Fri Sat | |
| dddd | Sunday Monday ... Friday Saturday | |
| E | 1 2 ... 6 7 | |
| Weeks in a year | w | 1 2 ... 52 53 |
| ww | 01 02 ... 52 53 | |
| Quarter | Q | 1 2 3 4 |
| AM/PM | A | AM PM |
Display the date in the specified language format
The format rules MMM/MMMM/ddd/dddd can be displayed in different forms depending on the current user's language preference. For instance, if you wish to present it in English style, you can append #EN# to the format rule.
Take the date June 20, 2024, as an example, with the format rule YY-MMM-DD. Depending on the system language of different accounts, it will be displayed as follows:
- 中文: 24-6月-20
- 日本語: 24-6月-20
- English: 24-Jun-20
If you set it to be displayed in the English format YY-MMM-DD#EN#, it will consistently show as 24-Jun-20, regardless of the system language.
Have questions about this article？ Send us feedback