Random Invalid date

Answered
Omkar kakade asked on September 5, 2018

Hello there,
 
System Details:
Chrome Version 68.0.3440.106 (Official Build) (64-bit)
flexmonster v2.3
Scenario: Unable to locate
Behaviour: Random
 
 
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.

Attachments:
correct_sample.csv

1 answer

Public
Tanya Gryshko Tanya Gryshko Flexmonster September 5, 2018

Hello, Omkar,
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.
Regards,
Tanya

Please login or Register to Submit Answer