error on importing reviews

At the same time you always get the error ?Incorrect date format no matter the way you set the date. I literally downloaded the CSV template file and only modified the post ID. Then uploaded and selected the exact way the date is put: m/d/yyyy h:mm

This was fixed in v7.0.15.

Are you sure when you tried you were using the latest version?

• This reply was modified 4 months, 1 week ago by Gemini Labs.

Also, if you look closely you’ll see that the CSV file uses the yyyy-mm-dd hh:mm:ss format…

https://prnt.sc/2ruKsaNcw0ed

Not on my side

Maybe Excel is visually formatting the date. Try opening it in a plain text editor.

The moment you edit the date you will always get that error. Same date in Excel, same in classic editor, and same in plugin.

https://prnt.sc/5YExU4Jd6gEG

https://prnt.sc/j0avwC2Z3CKl

https://prnt.sc/w8mdE1_v0fV-

I don’t understand why so much headache with a date field when you show the date on reviews as you wish anyway from the default WordPress.

I don’t understand why so much headache with a date field when you show the date on reviews as you wish anyway from the default WordPress.

Excel is a spreadsheet editor. It exports to CSV, but it is specifically made for spreadsheets which are intended to be visually viewed. CSV data is not. Dates can be inconsistent unless you specifically format the date column as one of the requirements CSV import formats.

Note that all formats require double digit months and days. US dates have the month before the day, EU dates have the day before the month. The reason why the CSV import is strict with dates is because when importing data into a website, the data has to be consistent, particularly when dealing with date formats.

For example: is 01/02/2024 January 2nd or February 1st? Depends on your location.