Hi, folks. 

I have a table imported (and updating every hour) via API from my business platform. There is a column "CreatedAt" with a date and time of order creation. 

Example data in this column: 2020-05-28T02:10:35+0200

Seems normal, but ZOHO does not recognise this as a "date&time" column and imports as plain text.

So, I try to set a new data type for this column. Here is how I do this and the problem I get.

1. Call the "change data type" command for a column, which is supposed to contain date&time.

2. I choose the "date&time" data type.

3. From available date&time formats I choose the one that looks like my original data 2020-05-28T02:10:35+0200

4. And I have wrong results. After conversion I get a data with 'T' (with apostrophes) while the should me T (without apostrophes). 

Now, the question. 

How should I do this? 

1. I have a source plain text data like this - 2020-05-28T02:10:35+0200

2. After conversion I get date&time like this - 2020-05-28'T'02:10:35+0200 (T with apostrophes)

3. I need date&time like this: 2020-05-28T02:10:35+0200 (T without apostrophes)

I suppose I need to correct this code, but no idea how exactly: 

Any help will be appreciated :)

Dariusz