Posted by stpaultim on Wed, Aug 19, 2020 - 10:35pm --- Updated: Aug 19 '20 - 10:42pm

I'm working on this now and I'm not quite sure how to format the dates in the CSV file that I'm importing. Any pointers?

I'm trying to import date and time. 

My first wild guess was to try this format 

2020-09-18T04-0500

Comments

Wed, Aug 19, 2020 - 11:30pm by stpaultim

Part of my problem, was that I was creating a spreadsheet of data to import and did not have my dates in UNIX timestamps.

Eventually, I found that with the use of Feeds Tamper module I was able to import dates if I started as UNIX timestamp AND I found a website where I could batch convert my dates to UNIX timestamps. 

https://www.epochconverter.com/batch

Rogelio's picture

Thu, Aug 20, 2020 - 9:34pm by Rogelio

Hi, i got it without Tamper, i used this format "2017-09-17T18:21:26-0500" it works for the Date field and Publish date too, works with XML or CSV