Options List ‐ Date

Customize the format of date type columns

	Code	Description
Date	d	Day of the month
	dd	Day of the month with leading zero
	ddd	Day of the week (3-letter abbreviation)	In local language
	dddd	Day of the week	In local language
	M	Month
	MM	Month with leading zero
	MMM	Name of the month (3-letter abbreviation)	In local language
	MMMM	Name of the month	In local language
	yy	Year (last 2 digits)
	yyyy	Year
Time	h	Hours (12-hour clock)
	hh	Hours (12-hour clock) with leading zero
	H	Hours (24-hour clock)
	HH	Hours (24-hour clock) with leading zero
	m	Minutes
	mm	Minutes with leading zero
	s	Seconds
	ss	Seconds with leading zero
	t	12-hour clock period in 1 character (a / p)	In local language
	tt	12-hour clock period (AM / PM)	In local language
Text	(others)	The character itself

Example: dddd, d/M/yyyy h:mm:sstt