Home Knowledge Base FAQ - Import Wizard Accepted Date Formats for Inside Your File

FAQ - Import Wizard

FAQ - Import Wizard

Import Wizard

Accepted Date Formats for Inside Your File


The best practice for the date format within your file is the ISO Standard of YYYY-MM-DD however the system will accept other formats as well. Overall we accept all ISO 8601 date formats, below is the listing of examples using April 5th, 2016. As a guideline you will always be right if your month number precedes your day number or if you use letters to describe the month.

 
YYYY-MM-DD 2016-04-05      
YYYY-MM-DD HH:MM 2016-04-05 11:30 2016-04-05 22:30    
YYYY-MM-DD HH:MM:SS 2016-04-05 11:30:05      
MM-DD-YYYY 04-05-2016 4-05-2016 04-5-2016 4-5-2016
M-D-Y 04-05-16 04-5-16 4-05-16 4-5-16
M-D 04-05 4-05 04-5 4-5
D-Mon-YYYY 05-Apr-2016 5-Apr-2016    
DMon 05Apr 5Apr    
Mon-D-YYYY Apr-05-2016 Apr-5-2016    
Month-D-YYYY April-05-2016 April-5-2016    
Day of Week, Month D, YYYY Tuesday, April 05,2016 Tuesday, April 5,2016    
Day of Wk, Month D, YYYY Tue, April 05, 2016 Tue, April 5,2016    
Day of Week, Mon D, YYYY Tuesday, Apr 05, 2016 Tuesday, Apr 5, 2016    
Day of Wk, Mon d, YYYY Tue, Apr 05, 2016 Tue, Apr 5, 2016