Title: post_date format help?
Last modified: August 31, 2016

---

# post_date format help?

 *  [amurado](https://wordpress.org/support/users/amurado/)
 * (@amurado)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/post_date-format-help/)
 * Hi,
 * I’ve managed to import my csv file in successfully, but the post_date column 
   isn’t working. All the dates in WordPress for each post were set to January 1,
   1970. I’ve tried various formats and even copied and pasted from the sample csv
   file, but I can’t seem to get it working. They’re most future dates, so the post_status
   is either published or future depending.
 * Formats I’ve tried:
    22/12/16 9:00 22/12/2016 13/09/13 0:00 (sample.csv format)
   2016/12/22 12/22/16
 * Any ideas?
 * Thanks!
 * [https://wordpress.org/plugins/really-simple-csv-importer/](https://wordpress.org/plugins/really-simple-csv-importer/)

Viewing 1 replies (of 1 total)

 *  [happyliu](https://wordpress.org/support/users/happyliu/)
 * (@happyliu)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/post_date-format-help/#post-6932223)
 * I used m/d/yyyy h:mm and it worked for me. I would select the whole column and
   format that column to be a ‘custom’ field and type in m/d/yyyy h:mm and then 
   ok.
 * But I wasn’t able to upload one that were ‘scheduled’ for a future date. But 
   I was able to upload them as ‘pending’ and then you can quick edit or bulk edit
   them to be a different date.

Viewing 1 replies (of 1 total)

The topic ‘post_date format help?’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/really-simple-csv-importer_c5cdac.
   svg)
 * [Really Simple CSV Importer](https://wordpress.org/plugins/really-simple-csv-importer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/really-simple-csv-importer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/really-simple-csv-importer/)
 * [Active Topics](https://wordpress.org/support/plugin/really-simple-csv-importer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/really-simple-csv-importer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/really-simple-csv-importer/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [happyliu](https://wordpress.org/support/users/happyliu/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/post_date-format-help/#post-6932223)
 * Status: not resolved