I need to convert datetimes between UTC and local.
Normally, I could just use the timezone offset, but the offset changes at different times of the year.
Are there any ways to use the timezone styling “America/Chicago” within AppGyver? Or does anyone know of open databases I could hit that would do the conversion for me using “America/Chicago”?
I think SET_TIMEZONE should work well for you if you want to use some specific timezone. But there is also an option to use timezone directly from user’s phone: FORMAT_DATETIME_LOCAL.
There’s actually quite many date related Formulas available so I’d start by going through those and checking how those can handle your use case.
Whoa! I COMPLETELY overlooked SET_TIMEZONE! That was the piece I was missing. Thank you @Tomi_Laakso!