Zoho Reports importErrors - ERROR: Invalid Date value
I am having problems importing Date data via the API. Initially, my table had one Date column (called `date_of_birth`) and the data imported fine.
However, I have just added a second Date column (called `datetime_registered`) to the table and when I try importing data, I get the following error...
"importErrors":"<nobr>[Line: 2 Field: 7] (04 Mar, 2016 15:17:34) -ERROR: Invalid Date value<\/NOBR><br><nobr>Import error, row skipped 2<\/nobr><\/br>"
...and that is despite my two date formats being exactly the same.
I tried changing the format of the dates, but I still get an error:
"importErrors":"<nobr>[Line: 2 Field: 7] (2016-03-04T15:17:34) -ERROR: Invalid Date value<\/NOBR><br><nobr>Import error, row skipped 2<\/nobr><\/br>"
Why is this error occurring and how to resolve?
Thanks in advance. :-)