I want to display my Event Start Time and Event End Time as ISO 8601 format.
I need it in this format so that when I export the csv and import into Adalo (no code app builder) that it will accept the time and date format correctly.
The “Local Start Time” field is the airtable user’s local time. They input the time there, then select the Event time zone. The “Event Time Zone” field has a formula to show the correct time in that time zone.
I want to also create a column to show the “Event Time Zone” in ISO 8601 format and with the correct UTC offset. I need this because I need to export this airtable and import it into Adalo as a csv.
I saw a user “Kuovonne” do something similar, but I can’t figure out the formula to get the correct format and utc offset.
This is the output that Kuovonne showed that I am looking for.
Solved! Go to Solution.
Thanks Scott and Kuovonne.
Scott, I used your video for my original calculations.
Kuovonne, I realized I needed to make the conversions from the local time since that would be in the correct gmt zone. Once I did that the times imported correctly.
Thanks to both of you for your help.