SOLVED

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

Go to solution
Anonymous
Not applicable

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
 
 

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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

We use Month/Date/year with slashes (e.g.03/25/2013) and it works correctly.

View solution in original post

4 REPLIES 4
Josh_Hill13
Level 10 - Champion Alumni

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

Good question. What does Marketo show when you look at a lead record with a date field?
Anonymous
Not applicable

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

We use Month/Date/year with slashes (e.g.03/25/2013) and it works correctly.
Anonymous
Not applicable

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

Yes, same here; mm/dd/yyyy.
Anonymous
Not applicable

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

Thanks, all!