Title: Invalid date format Last modified: May 22, 2020 --- # Invalid date format * Resolved [logicbasebalili](https://wordpress.org/support/users/logicbasebalili/) * (@logicbasebalili) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/) * Hi! I have a problem importing orders. It says Invalid date format. I copied the date format on your sample csv and yet I am having this error. Did I miss something? Viewing 10 replies - 1 through 10 (of 10 total) * Plugin Author [WebToffee](https://wordpress.org/support/users/webtoffee/) * (@webtoffee) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12873581) * Hi [@logicbasebalili](https://wordpress.org/support/users/logicbasebalili/), * We are able to import orders successfully in our test environment using the date formats DD-MM-YYYY, MM/DD/YYYY, and YYYY-MM-DD. Please make sure that you use any of these date formats in your CSV file. * If the issue still persists then please share with us your importing CSV file so that we can check it. You may please share it with us by uploading to Google Drive or any similar service and sharing the link. Or else you may please send it to us via [support.](https://www.webtoffee.com/contact/) * [craigshort](https://wordpress.org/support/users/craigshort/) * (@craigshort) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12895535) * Hi [@webtoffee](https://wordpress.org/support/users/webtoffee/) I am having the same issue. I have exported from live and trying to import straight onto my test and getting `Skipped. Invalid date format` * I have not edited or touched the file for it to be invalid. This is how it looks: 26/05/2020 13:52 * Thanks * [Leocadie](https://wordpress.org/support/users/leocadie/) * (@leocadie) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12902261) * Exactly the same issue than [@craigshort](https://wordpress.org/support/users/craigshort/) for me, and same format (exported with your plugin), so i follow the subject 🙂 * [Leocadie](https://wordpress.org/support/users/leocadie/) * (@leocadie) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12902272) * Yeah, i just found the solution : you need to change the dd/mm/aaaa for aaaa- mm-dd and it works ! I hope it helps, and that your list is not too long… 😉 * [tonka28](https://wordpress.org/support/users/tonka28/) * (@tonka28) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12937388) * [@leocadie](https://wordpress.org/support/users/leocadie/) I’m having this issue too, when you say you need to change the date format, are you talking changing the format in Site A and Site B to Y-m-d? Sorry man, I really want to get this working but your comment is a little odd as in I’m not sure where we’re needing to change, or if _aaaa-mm-dd_ is in fact Y-m-d in WordPress terms… any and all help is appreciated! * Thread Starter [logicbasebalili](https://wordpress.org/support/users/logicbasebalili/) * (@logicbasebalili) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12937404) * [@tonka28](https://wordpress.org/support/users/tonka28/) I already found a fix on this. On my end, I need to change my date format to dd-mm-yyyy h:mm:ss - This reply was modified 5 years, 10 months ago by [logicbasebalili](https://wordpress.org/support/users/logicbasebalili/). * [tonka28](https://wordpress.org/support/users/tonka28/) * (@tonka28) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12937429) * [@logicbasebalili](https://wordpress.org/support/users/logicbasebalili/) yeah, I understand that date formats need to change, but what I’m asking is: - Site A needs to be set to d-m-Y (WordPress syntax) - Then process the order export - Site B is then set to d-m-Y - Then process the order import without failure - Is that explanation correct? * Plugin Author [WebToffee](https://wordpress.org/support/users/webtoffee/) * (@webtoffee) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12942429) * Hi [@tonka28](https://wordpress.org/support/users/tonka28/), * The plugin supports the date format yyyy/mm/dd, dd-mm-yyyy, yyyy-mm-dd, and mm/ dd/yyyy. Please make sure that the date format used in the importing CSV file is any of the mentioned formats for a successful import. * [tonka28](https://wordpress.org/support/users/tonka28/) * (@tonka28) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12942438) * [@webtoffee](https://wordpress.org/support/users/webtoffee/) yeah, I got it and gave you a 5-star 🤙 * Plugin Author [WebToffee](https://wordpress.org/support/users/webtoffee/) * (@webtoffee) * [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12946234) * Hi [@tonka28](https://wordpress.org/support/users/tonka28/), * Thank you for leaving the review. Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Invalid date format’ is closed to new replies. * ![](https://ps.w.org/order-import-export-for-woocommerce/assets/icon-256x256. gif?rev=3133964) * [Order Export & Order Import for WooCommerce](https://wordpress.org/plugins/order-import-export-for-woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/order-import-export-for-woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/order-import-export-for-woocommerce/reviews/) * 10 replies * 5 participants * Last reply from: [WebToffee](https://wordpress.org/support/users/webtoffee/) * Last activity: [5 years, 10 months ago](https://wordpress.org/support/topic/invalid-date-format-3/#post-12946234) * Status: resolved