# Help. Calendar view not displaying correctly

**URL:** <https://community.glideapps.com/t/help-calendar-view-not-displaying-correctly/2273>\
**Category:** Report a Bug\
**Created:** [November 22, 2019, 5:41am UTC](https://community.glideapps.com/t/help-calendar-view-not-displaying-correctly/2273 "2019-11-22T05:41:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gary\_knoetze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_knoetze/32/1736_2.png) [@gary\_knoetze](https://community.glideapps.com/u/gary_knoetze)\
**Post date:** [November 22, 2019, 5:41am UTC](https://community.glideapps.com/t/help-calendar-view-not-displaying-correctly/2273/1 "2019-11-22T05:41:40Z")

</div>

Im building a CRM app that will utilize a calender tab. When I select a a list view layout, all my upcoming appointments are visible. When I select calendar layout it simply says No upcoming events (even though there are some loaded onto my sheet.) also adding a new event in calendar view adds it to my sheet, but still shows no upcoming events.

 ![calender%20view](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/375ea744dde38279172fe7ec86be5878570d0dfd.png)  
(Second image in replies - can only post one image as I’m new)

Additionally, the date and time gets automatically messed up, even though I’m adding it in the required format. it replaces AM/PM with this weird 000Z on the end.

It’s literally the last thing I need finishing, and I’ve been struggling with this for 2 days now.  
PS, I’m using this on IOS. Haven’t tested it on Android yet.

---

<div class="post-metadata">

**Author:** ![gary\_knoetze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_knoetze/32/1736_2.png) [@gary\_knoetze](https://community.glideapps.com/u/gary_knoetze)\
**Post date:** [November 22, 2019, 5:42am UTC](https://community.glideapps.com/t/help-calendar-view-not-displaying-correctly/2273/2 "2019-11-22T05:42:18Z")

</div>

![list%20view](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d32cedba32b4587da4813b18796c92f8ace8e348.png)

---

<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:** [November 22, 2019, 5:57am UTC](https://community.glideapps.com/t/help-calendar-view-not-displaying-correctly/2273/3 "2019-11-22T05:57:37Z")

</div>

Your WHEN needs to point to a date column. You have it pointing to Name.

The Date is a properly formatted Date Timestamp. You can use formulas in your sheet to display it a different way if you choose. Z stands for Zulu, which is Greenwich Mean Time.

> <https://stackoverflow.com/questions/29281935/what-exactly-does-the-t-and-z-mean-in-timestamp>

I haven’t fully tested it but I’ve seen mixed results with people adjusting the column formatting in the sheet. I tend to avoid that and use formulas in a new column, like `=ARRAYFORMULA(TEXT(D2:D, "MM/DD/YYYY"))`

---

<div class="post-metadata">

**Author:** ![gary\_knoetze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_knoetze/32/1736_2.png) [@gary\_knoetze](https://community.glideapps.com/u/gary_knoetze)\
**Post date:** [November 22, 2019, 6:04am UTC](https://community.glideapps.com/t/help-calendar-view-not-displaying-correctly/2273/4 "2019-11-22T06:04:20Z")

</div>

AAAH! thanks so much! Been pulling out my hair for days on this!

---

<div class="post-metadata">

**Author:** ![gary\_knoetze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_knoetze/32/1736_2.png) [@gary\_knoetze](https://community.glideapps.com/u/gary_knoetze)\
**Post date:** [November 22, 2019, 6:07am UTC](https://community.glideapps.com/t/help-calendar-view-not-displaying-correctly/2273/5 "2019-11-22T06:07:46Z")

</div>

😀