I'm trying to import a data set which send a Date column in the format below:

2016-07-19T17:35:25-03:00

 (it comes with a "T" between day and Hour)

When I set the Date field in the import process to:

yyyy-MM-dd'T'HH:mm:ssZ (which is standard in the list of date formats available in Zoho Reports)

IT won't import the column, saying the format is not like the imported data.

The alternative is to choose the column, Find and Replace the "T" for a "space", and then change the format to the one below:

yyyy-MM-dd HH:mm:ss  (removing both the "T" and the "Z" at the end).

The problem with this solution is that when we schedule a new import, the new data for that column will be blank as the original format is not accepted exactly because of the "T" in the middle of the sentences.

I have tried to create a Formula column to copy the original one and then treat the Formula Column, but the system wont allow me to do that.

What should I do?

Tks,