I am trying to convert a string column to a date. I’ve used DATETIME_PARSE(Date)
The formula works for some records, but half of them return an ERROR.
All of the dates were pasted from the same document, so they are not different in any way.
I tried ...
I’m using a table that takes a text (email body) and returns various elements, such as date.
So I have a date written in one column like this:
November 14, 2020
December 10, 2020
I use several formulas to get this info, such as FIND, MID and LEN. The...
But the original field doesn’t have any timezone at all, it’s just text. So why does it convert to a timezone at all? I’m in EDT timezone and I have checked all the fields to make sure the GMT checkbox is unchecked.
I used the SET_TIMEZONE function t...