Title: Importing Comments CSV – Date is wrong
Last modified: August 18, 2016

---

# Importing Comments CSV – Date is wrong

 *  Resolved [drummergirl](https://wordpress.org/support/users/drummergirl/)
 * (@drummergirl)
 * [18 years, 9 months ago](https://wordpress.org/support/topic/importing-comments-csv-date-is-wrong/)
 * I’m moving a blog from one site to another for a client, which involved exporting
   his comments db to a csv file, cleaning it up and then importing it to the new
   site. When I imported, all the data came through perfectly except the dates all
   show 12:00:00am on December 31, 1969 for every single comment. When I open the
   csv file, the dates are correct. Any idea how I can fix this?
 * I used neo office to open the file and edit the data, if that piece of info helps
   anything. Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [drummergirl](https://wordpress.org/support/users/drummergirl/)
 * (@drummergirl)
 * [18 years, 9 months ago](https://wordpress.org/support/topic/importing-comments-csv-date-is-wrong/#post-610952)
 * I should also add here that when I imported the blog posts using the same method,
   the dates were fine. I am importing and exporting via phpmyadmin.
 *  Thread Starter [drummergirl](https://wordpress.org/support/users/drummergirl/)
 * (@drummergirl)
 * [18 years, 9 months ago](https://wordpress.org/support/topic/importing-comments-csv-date-is-wrong/#post-611004)
 * Ok – nevermind. I imported the old table into the new database then changed the
   names of the tables, which swapped the new data with the old data. Perfect.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Importing Comments CSV – Date is wrong’ is closed to new replies.

## Tags

 * [Comments](https://wordpress.org/support/topic-tag/comments/)
 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [dates](https://wordpress.org/support/topic-tag/dates/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 1 participant
 * Last reply from: [drummergirl](https://wordpress.org/support/users/drummergirl/)
 * Last activity: [18 years, 9 months ago](https://wordpress.org/support/topic/importing-comments-csv-date-is-wrong/#post-611004)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics