Reference > Column types

Set Supported Date Formats in the Preferences window according to how you want to interpret values as dates.

Format	Meaning
d	The day as number without a leading zero (1 to 31)
dd	The day as number with a leading zero (01 to 31)
ddd	The abbreviated localized day name (e.g. 'Mon' to 'Sun'). Uses the locale to localize the name.
dddd	The long localized day name (e.g. 'Monday' to 'Sunday'). Uses the locale to localize the name.
M	The month as number without a leading zero (1 to 12).
MM	The month as number with a leading zero (01 to 12)
MMM	The abbreviated localized month name (e.g. 'Jan' to 'Dec'). Uses the locale to localize the name.
MMMM	The long localized month name (e.g. 'January' to 'December'). Uses the locale to localize the name.
yy	The year as two digit number (00 to 99).
yyyy	The year as four digit number. If the year is negative, a minus sign is prepended in addition.

For example:

•To support a date such as 31/1/2019 add a supported date format: d/M/yyyy

•To support a date such as 1-31-19 add a supported date format: M-d-yy

List the date formats in order of preference, with the most likely to be used first.

Dates with only two year digits, are treated as a date between 1900 and 1999. E.g. "31/1/19" is interpreted in d-M-yy format as 31st January 1919.

Add today date to a dataset using input file meta information or using the Stamp transform.

Values that are in a recognized date format will be treated as dates in transforms such as: Calculate, Compare, Filter, If and Sort. Supporting large numbers of date formats will slow down these transforms.

Change the format of dates using the DateTime Format transform.

Do date calculations, such as calculating the number of days between 2 dates, using the Calculate or Javascript transform.

Convert between ISO standard datetimes and milliseconds since 1st Jan 1970 using the Calculate transform.

Convert an ISO standard datetimes (e.g. 2020-10-16T01:51) into separate date and time columns by using the Split Cols transform on the "T" delimiter.

Add missing dates in a sequence using Sequence.

Check date values are as expected in a column using the Verify transform.

Generate random dates using the Random transform.

Days of the week in ddd format in some of the more commonly used locales are:

Day of week	English/United Kingdom	English/United States	French/France	German/Germany	Italian/Italy	Spanish/Spain
1	Sun	Sun	dim.	So.	dom	dom
2	Mon	Mon	lun.	Mo.	lun	lun
3	Tue	Tue	mar.	Di.	mar	mar
4	Wed	Wed	mer.	Mi.	mer	mié
5	Thu	Thu	jeu.	Do.	gio	jue
6	Fri	Fri	ven.	Fr.	ven	vie
7	Sat	Sat	sam.	Sa.	sab	sáb

Days of the week in dddd format in some of the more commonly used locales are:

Day of week	English/United Kingdom	English/United States	French/France	German/Germany	Italian/Italy	Spanish/Spain
1	Sunday	Sunday	dimanche	Sonntag	domenica	domingo
2	Monday	Monday	lundi	Montag	lunedì	lunes
3	Tuesday	Tuesday	mardi	Dienstag	martedì	martes
4	Wednesday	Wednesday	mercredi	Mittwoch	mercoledì	miércoles
5	Thursday	Thursday	jeudi	Donnerstag	giovedì	jueves
6	Friday	Friday	vendredi	Freitag	venerdì	viernes
7	Saturday	Saturday	samedi	Samstag	sabato	sábado

Months of the year in MMM format in some of the more commonly used locales are:

Month of year	English/United Kingdom	English/United States	French/France	German/Germany	Italian/Italy	Spanish/Spain
1	Jan	Jan	janv.	Jan.	gen	ene
2	Feb	Feb	févr.	Feb.	feb	feb
3	Mar	Mar	mars	März	mar	mar
4	Apr	Apr	avr.	Apr.	apr	abr
5	May	May	mai	Mai	mag	may
6	Jun	Jun	juin	Juni	giu	jun
7	Jul	Jul	juil.	Juli	lug	jul
8	Aug	Aug	août	Aug.	ago	ago
9	Sept	Sep	sept.	Sept.	set	sept
10	Oct	Oct	oct.	Okt.	ott	oct
11	Nov	Nov	nov.	Nov.	nov	nov
12	Dec	Dec	déc.	Dez.	dic	dic

Months of the year in MMMM format in some of the more commonly used locales are:

Month of year	English/United Kingdom	English/United States	French/France	German/Germany	Italian/Italy	Spanish/Spain
1	January	January	janvier	Januar	gennaio	enero
2	February	February	février	Februar	febbraio	febrero
3	March	March	mars	März	marzo	marzo
4	April	April	avril	April	aprile	abril
5	May	May	mai	Mai	maggio	mayo
6	June	June	juin	Juni	giugno	junio
7	July	July	juillet	Juli	luglio	julio
8	August	August	août	August	agosto	agosto
9	September	September	septembre	September	settembre	septiembre
10	October	October	octobre	Oktober	ottobre	octubre
11	November	November	novembre	November	novembre	noviembre
12	December	December	décembre	Dezember	dicembre	diciembre