How should "Date" information be formatted in a CSV for import? | Community
Skip to main content
A
Anonymous
March 25, 2013
Solved

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

  • March 25, 2013
  • 4 replies
  • 1980 views

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.
Best answer by
We use Month/Date/year with slashes (e.g.03/25/2013) and it works correctly.

4 replies

Josh_Hill13
Josh_Hill13
Level 10
March 26, 2013
Good question. What does Marketo show when you look at a lead record with a date field?
A
Anonymous
Accepted solution
March 26, 2013
We use Month/Date/year with slashes (e.g.03/25/2013) and it works correctly.
A
Anonymous
March 26, 2013
Yes, same here; mm/dd/yyyy.
A
Anonymous
March 26, 2013
Thanks, all!
Terms & ConditionsAccessibility statement

Loading footer...