The creation date shown in the example template is 9/01/17 16:40 (when open in Excell).
The dates of my reviews seem to be the same: 7/08/17 9:14. But weirdly, this date displays on the site as Aug 17, 0007
Is the format of the date in the example template correct or is the Product Review App not interpreting the dates correctly?
The 'Import using month/day/year date format' was left unticked because we don'ty use american dates if that makes sense.
Any help would be much appreciated as our imported reviews look fake!
As mentioned above, seems to be a compatibility issue with excel's date format.
This worked for me:
After completing the reviews, leaving the created dates blank for now, save and close your csv file.
Open with text edit (or similar, i'm on a mac), and copy and paste the date format from the csv template that you download from the app.
Once pasted back into the end of each line item in your text reader, update the dates, save, close, and your done.
Hope this works for you also.