Zoho Analytics Formula Column
Date column imported from Zoho workspace gets changed to text type. I tried converting the format, however it gives weird results. To counter this, I created a formula column - this however doesnt give me any output. It's always blank. Not sure, if the formula is right..
The formula is - str_to_date( "created time",'%d/%m/%Y')
the imported column data is something like - May 20, 2021 06:46 PM which gets treated as text when imported.