I have timestampz data that I need to convert to a pacific time date. The format is "2021-11-24T10:00:00+00:00." It is currently stored in UTC time.
I tried =value(left(g2,10)), but the date is not matching up with other records that I have that are already converted in some instances. I also tried =value(left(g2,10)-(8/24)) and it still does not match up.
Any advice is appreciated. Thank you.