Date Formatter: Timezone conversion (Working with Webflow)

I’m trying to use the Date Formatter to convert this:
Wed Aug 12 2020 19:00:00 GMT+0000 (Coordinated Universal Time)
into this:
8/12/2020 3:00 PM EDT

Is there not a way to do the timezone conversion?

Unfortunately Webflow treats their dates like this and makes them so hard to work with haha

When I import directly into Parabola from the Webflow CMS, I get a date that looks like this:
2020-08-12T17:00:00.000Z
equally hard to work with, unfortunately :slight_smile:

I tried doing the old format like this:
YYYY-MM-DDTHH:mm:ss.000Z
and new format like this:
MM/DD/YYYY hh:mm A
and got close, but I’m not sure how to set the timezone to Eastern. tips?

Hey Jake! We do not have good support for timezone conversions right now.

The best you can do is convert it to Unix time (using X as the format code), and then add or subtract the number of seconds required to shift your time into your desired timezone, and then convert it back out of unix and into a more normal date time format. Just be aware that its tough/not possible to account for daylight savings time in this method.

Ok thanks Brian. Maybe I’ll try this specific scenario in Integromat instead.

Consider this a feature request for better date formatting/conversion options :slight_smile:
Thanks!

Totally fair! Feel free to post that over in #feature-requests as well!

Thanks Brian.

Done: More Date/Time Conversion options (convert for time zones)