Title: Importing dates
Last modified: April 17, 2020

---

# Importing dates

 *  Resolved [gmorg313](https://wordpress.org/support/users/gmorg313/)
 * (@gmorg313)
 * [6 years ago](https://wordpress.org/support/topic/importing-dates-2/)
 * Hi, I’m having trouble importing dates from a .csv file. In the file I’m trying
   to import each row has an entry in a column called Date formatted ’18-04-2008′,’
   26-04-2008′, etc. When I import this into a column with the date format they 
   all come out as 30/11/-0001.
 * I’m very new to this, so this is likely something very simple, I just can’t figure
   out what it is, and would appreciate some help…
 * thanks!

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

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years ago](https://wordpress.org/support/topic/importing-dates-2/#post-12689494)
 * Hi,
 * Welcome!
 * WP Data Access does not support CSV imports. Only SQL files… Are you at the right
   support forum? 🙂
 * Bes regards,
    Peter
 *  Thread Starter [gmorg313](https://wordpress.org/support/users/gmorg313/)
 * (@gmorg313)
 * [6 years ago](https://wordpress.org/support/topic/importing-dates-2/#post-12689512)
 * Oops… I missed a step, sorry! I’ve converted the csv to an sql file… In the SQL
   file they’re formatted 18-04-2008′, ’26-04-2008′, etc.
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years ago](https://wordpress.org/support/topic/importing-dates-2/#post-12689969)
 * No problem!
 * Can you sent me the SQL file?
 * If you sent me a private message from the plugin website (wpdataaccess.com), 
   I’ll reply to give you my email adress.
 * Best regards,
    Peter
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years ago](https://wordpress.org/support/topic/importing-dates-2/#post-12699532)
 * Topic closed!
 * For anyone interested in the solution:
 * Format in SQL insert must be: YYYY-MM-DD
    For other formats use: STR_TO_DATE 
   Example DD-MM-YYYY: STR_TO_DATE(’18-04-2008′,’%d-%m-%Y’)
 * Peter
 *  [sonisitez](https://wordpress.org/support/users/sonisitez/)
 * (@sonisitez)
 * [6 years ago](https://wordpress.org/support/topic/importing-dates-2/#post-12799551)
 * How I can using this Peter?
    DD-MM-YYYY: STR_TO_DATE(’18-04-2008′,’%d-%m-%Y’)
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years ago](https://wordpress.org/support/topic/importing-dates-2/#post-12800702)
 * Where do you want to use this? And how?
 * Thanks,
    Peter

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

The topic ‘Importing dates’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [date formats](https://wordpress.org/support/topic-tag/date-formats/)
 * [importing](https://wordpress.org/support/topic-tag/importing/)

 * 6 replies
 * 3 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/importing-dates-2/#post-12800702)
 * Status: resolved