I am trying to determine if an appointment date (stored as UTC) is on the same day or a different day depending on the timezone.
I think I know how to do this with an IF statement in general:
IF(“Date in CTZ1”=“Date in CTZ2",“same”,“different”)
but I don’t know if they work with dates and times.
In the image Call 1 is a date in UTC. I want to compare if that date is the same in Sydney (CTZ1) as it is in Nicosia (CTZ2) - which it isn’t - Sydney is on the next day.
I need another field that says ‘same’ or ‘not same’, but I can’t figure out how to do it.
Help or ideas are appreciated.