Skip to main content
Mar 25, 2013 10:42 PM UTC
Solved

How should "Date" information be formatted in a CSV for import?

I want to import a list of leads with a date associated with each.  I've created a custom field with a type of Date.  I want to use the new Wait Until (+/-) Days feature.

What is the proper input format of the date information in the CSV file before importing?  

Month/Date/year with slashes? 03/25/2013

No slashes?  03252013

Dashes?  03-25-2013

Year first with dashes?  2013-03-25

Euro Style?  25-03-2013
 
 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Accepted solution
Mar 26, 2013 12:19 AM UTC
We use Month/Date/year with slashes (e.g.03/25/2013) and it works correctly.

4 replies

Josh_Hill13
Level 10
Mar 26, 2013 12:08 AM UTC
Good question. What does Marketo show when you look at a lead record with a date field?
Translate
Accepted solution
Mar 26, 2013 12:19 AM UTC
We use Month/Date/year with slashes (e.g.03/25/2013) and it works correctly.
Translate
Mar 26, 2013 12:46 PM UTC
Yes, same here; mm/dd/yyyy.
Translate
Mar 26, 2013 2:12 PM UTC
Thanks, all!
Translate