Chrome Version 68.0.3440.106 (Official Build) (64-bit)
Scenario: Unable to locate
Currently I am facing the problem after uploading the CSV. Sometimes CSV shows invalid date and sometime it does not.
I have attached CSV. Please Check.
Thank you for writing to us.
We have checked the CSV file you attached and noticed that your dates are not in ISO 8601 date format.
However, as an input date format, Flexmonster Pivot expects ISO 8601 date (other formats may be used, but results can be unexpected). You can check this format here: https://www.w3.org/TR/NOTE-datetime.
We suggest specifying the dates in this format. Please let me know if it helps.