# Add to calendar with multiple options

**URL:** <https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402>\
**Category:** Ask for Help\
**Created:** [May 5, 2023, 7:38pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402 "2023-05-05T19:38:47Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 14, 2023, 11:32am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/10 "2023-05-14T11:32:55Z")

</div>

‘T’ is a code that returns time. If you wrap it in single quotes, then it will be interpreted as a letter instead of time.

This should help.

> [@new "Respect time zone" support for Date & Time column in Glide Tables & Airtable](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/15):
>
> Try this. yyyy-MM-dd'T'HH:mm:ss'Z' [image] Or, this if you want the timezone offset instead. yyyy-MM-dd'T'HH:mm:ssZZ [image]

This is also an easy alternative to using the Format Date.

> [@Convert Date and Time to Zulu](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/34):
>
> @Jeff_Hager I just figured this out recently, You can do it by using a JavaScript column and returning the column itself.

> [@saucy](#):
>
> How do I specify the time offset? I’ve tried various different variations based on the example provided on the Agical page and nothing is working.

The agical document that @ThinhDinh linked to shows how the data should be structured and how to specify the offset.

 ![Screenshot_20230514-062048](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec0c2644c9988c5c29c0e770d72d5abf7209d0e5.png)

---

_[View the full topic](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402)._