Date of entry being set to ‘January 1, 1970′ on entry import

I am working on a new site design, and would like to import the entries from my current site into Formidable for testing. (I am using XAMPP on a Mac, if it matters)

I have successfully exported/imported other form entries onto my test site, but I am having trouble with one form. When I export the entries, the ‘date’ field has the correct date in the CSV file. I match the fields up on the Import screen, and the dates are all imported with January 1, 1970 as the date of the event.

It’s not a big deal since it is a test site, but I would like to get them working if possible. It will stop me from entering a few entries again in the future :)


Attachment:
Screen Shot 2012-06-08 at 1.56.25 PM

What format is the date in in the csv?

2012-07-17 00:00:00 is under date.  I also have a time field that is just a standard 24-hour date format.

Can you remove the 00:00:00 from the date column? The time field options will need to match the options that show in your time field.

That fixed it.

Thanks

Topic closed.