Resources for converting datetime between UTC & local?

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!