Compatible date formats

When uploading contact data as dates, e.g: as a Custom Field of "Birthday", there is an expansive list of date formats that are supported, as shown below.

If the date format used in your CSV file is not consistent, e.g: you use more than one date format, you may see:

An alert asking you to confirm your preferred format before proceeding with your file upload;
An incompatibility error, asking you to ignore the column/field to proceed with your import (you can correct your formatting and re-upload the file);
Individual data cells may be skipped and noted in your Import Overview.

Supported date formats

dd/mm/yy	mm/yyyy/dd	dd/mm/yyyy	mm/yy/dd
dd-mm-yy	mm-yyyy-dd	dd-mm-yyyy	mm-yy-dd
dd.mm.yy	mm.yyyy.dd	dd.mm.yyyy	mm.yy.dd
ddmmyy	mmyyyydd	ddmmyyyy	mmyydd
dd mm yy	mm yyyy dd	dd mm yyyy	mm yy dd
dd/yy/mm	yyyy/dd/mm	dd/yyyy/mm	yy/dd/mm
dd-yy-mm	yyyy-dd-mm	dd-yyyy-mm	yy-dd-mm
dd.yy.mm	yyyy.dd.mm	dd.yyyy.mm	yy.dd.mm
ddyymm	yyyyddmm	ddyyyymm	yyddmm
dd yy mm	yyyy dd mm	dd yyyy mm	yy dd mm
mm/dd/yy	yyyy/mm/dd	mm/dd/yyyy	yy/mm/dd
mm-dd-yy	yyyy-mm-dd	mm-dd-yyyy	yy-mm-dd
mm.dd.yy	yyyy.mm.dd	mm.dd.yyyy	yy.mm.dd
mmddyy	yyyymmdd	mmddyyyy	yymmdd
mm dd yy	yyyy mm dd	mm dd yyyy	yy mm dd
mm/yy/dd	dd/mm/yy	mm/yyyy/dd	dd/mm/yyyy
mm-yy-dd	dd-mm-yy	mm-yyyy-dd	dd-mm-yyyy
mm.yy.dd	dd.mm.yy	mm.yyyy.dd	dd.mm.yyyy
mmyydd	ddmmyy	mmyyyydd	ddmmyyyy
mm yy dd	dd mm yy	mm yyyy dd	dd mm yyyy
yy/dd/mm	dd/yy/mm	yyyy/dd/mm	dd/yyyy/mm
yy-dd-mm	dd-yy-mm	yyyy-dd-mm	dd-yyyy-mm
yy.dd.mm	dd.yy.mm	yyyy.dd.mm	dd.yyyy.mm
yyddmm	ddyymm	yyyyddmm	ddyyyymm
yy dd mm	dd yy mm	yyyy dd mm	dd yyyy mm
yy/mm/dd	mm/dd/yy	yyyy/mm/dd	mm/dd/yyyy
yy-mm-dd	mm-dd-yy	yyyy-mm-dd	mm-dd-yyyy
yy.mm.dd	mm.dd.yy	yyyy.mm.dd	mm.dd.yyyy
yymmdd	mmddyy	yyyymmdd	mmddyyyy
yy mm dd	mm dd yy	yyyy mm dd	mm dd yyyy
dd/mm/yyyy	mm/yy/dd	dd/mm/yy	mm/yyyy/dd
dd-mm-yyyy	mm-yy-dd	dd-mm-yy	mm-yyyy-dd
dd.mm.yyyy	mm.yy.dd	dd.mm.yy	mm.yyyy.dd
ddmmyyyy	mmyydd	ddmmyy	mmyyyydd
dd mm yyyy	mm yy dd	dd mm yy	mm yyyy dd
dd/yyyy/mm	yy/dd/mm	dd/yy/mm	yyyy/dd/mm
dd-yyyy-mm	yy-dd-mm	dd-yy-mm	yyyy-dd-mm
dd.yyyy.mm	yy.dd.mm	dd.yy.mm	yyyy.dd.mm
ddyyyymm	yyddmm	ddyymm	yyyyddmm
dd yyyy mm	yy dd mm	dd yy mm	yyyy dd mm
mm/dd/yyyy	yy/mm/dd	mm/dd/yy	yyyy/mm/dd
mm-dd-yyyy	yy-mm-dd	mm-dd-yy	yyyy-mm-dd
mm.dd.yyyy	yy.mm.dd	mm.dd.yy	yyyy.mm.dd
mmddyyyy	yymmdd	mmddyy	yyyymmdd
mm dd yyyy	yy mm dd	mm dd yy	yyyy mm dd

What can we help you with?

Contacts

Supported date formats

Comments

What can we help you with?

Contacts

Compatible date formats

Supported date formats

Related articles