Hi, 

I have a time column, where I have:

- Time of some event (order creation) in a format 2018-11-13T18:04:47+0100 (plain text)

- I need to create a column containing only a date 2018-11-13 (date)

I try to use a calculated column with a formula using date() formula, and it does not work.

Any ideas?

I CANNOT convert or do anything with the source "time" column, it is imported every hour and any new records are in the same format.