Custom Date and Time Display Formats

I. Custom Date/Time Formats in Autonumber Fields

Format	Output
d	Day of the month (1–31)
dd	Day of the month (01–31)
ddd	Abbreviated name of the day of the week
dddd	Full name of the day of the week
h	Hour (12-hour clock, 1–12)
hh	Hour (12-hour clock, 01–12)
H	Hour (24-hour clock, 0–23)
HH	Hour (24-hour clock, 00–23)
m	Minute (0–59)
mm	Minute (00–59)
M	Month (1–12)
MM	Month (01–12)
MMM	Abbreviated month name
MMMM	Full month name
s	Second (0–59)
ss	Second (00–59)
tt	AM/PM designator
y	Year (0–99)
yy	Year (00–99)
yyy	Year (minimum three digits)
yyyy	Year (four digits)
yyyyy	Year (five digits)

By combining the above formats with separators (such as -, /, etc.), you can generate the desired date/time format.

	Format	Output
Year	YY	70 71 ... 29 30 (last two digits of year)
	YYYY	1970 1971 ... 2029 2030
Month	M	1 2 ... 11 12
	MM	01 02 ... 11 12
	MMM	Jan Feb ... Nov Dec
	MMMM	January February ... November December
Day	D	1 2 ... 30 31
	DD	01 02 ... 30 31
Day of Year	DDD	1 2 ... 364 365
	DDDD	001 002 ... 364 365
Weekday	d	0 1 ... 5 6
	dd	Su Mo Tu ... Fr Sa
	ddd	Sun Mon Tue ... Fri Sat
	dddd	Sunday Monday ... Friday Saturday
	E	1 2 ... 6 7
Week of Year	w	1 2 ... 52 53
	ww	01 02 ... 52 53
Quarter	Q	1 2 3 4
AM/PM	A	AM PM

By combining these formats with separators (such as -, /, etc.), you can customize the output format as needed.

The formats MMM / MMMM / ddd / dddd can adapt to the user's system language.

To force a specific language (e.g., English), append #EN# to the format.

Example (Date: 2024-06-20, Format: YY-MMM-DD)

To always display in English regardless of system language:

YY-MMM-DD#EN# → 24-Jun-20

Was this document helpful?