Hi,

when importing data to Zoho Reports the column with the date isn't identified.

The column has the dates formatted in ISO-standard  2014-01-04T12:15:00.000Z

I´ve tried to specify the date format to  "yyyy-MM-dd'T'HH:mm:ss.SSSZ".but a error is shown.

Also I tried to transform the date format in a new column with following structure:

yyyy-MM-dd hh:mm:ss

I choosed the right date format but a error is shown again. 

Edit: 

with formula "convert_string_to_date" I could define the part of the date but not the daytime. Is there any possibility?

Kind regards,

Andi