# Calendar showing things on wrong date

**URL:** <https://connect.superhuman.com/t/calendar-showing-things-on-wrong-date/44857>\
**Category:** Ask the Community\
**Created:** [December 1, 2023, 6:04pm UTC](https://connect.superhuman.com/t/calendar-showing-things-on-wrong-date/44857 "2023-12-01T18:04:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Karen\_Kenjosian](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/karen_kenjosian/32/39311_2.png) [@Karen\_Kenjosian](https://connect.superhuman.com/u/Karen_Kenjosian)\
**Post date:** [December 1, 2023, 6:04pm UTC](https://connect.superhuman.com/t/calendar-showing-things-on-wrong-date/44857/1 "2023-12-01T18:04:56Z")

</div>

Hi there, I’m a big fan of Coda and have been using it for my team’s content calendar. However, recently (this week) all of my posts are showing up on the calendar a day early. The publish dates are correct, but the display is wrong, which is very frustrating.  
Anyone have any suggestions? My team leader wants me to use a Google template, but I do not. I like this so much better.

 ![Coda Content Calendar Trouble Shooting](https://global.discourse-cdn.com/coda1/original/3X/c/f/cf0a6d58319c5010e29a664a36cfc1b0668a33f1.png)

---

<div class="post-metadata">

**Author:** ![Max\_OBrien](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/max_obrien/32/49285_2.png) [@Max\_OBrien](https://connect.superhuman.com/u/Max_OBrien)\
**Post date:** [December 3, 2023, 4:02pm UTC](https://connect.superhuman.com/t/calendar-showing-things-on-wrong-date/44857/2 "2023-12-03T16:02:28Z")

</div>

i cant be sure about this, but whenever dates behave oddly,  
i always look to see if the date-column has a time-value set.

when a date is stored in coda (and most apps) it is really a big floating-point number.  
the integer part defines the day (nimber of days since 01-jan-1970)

and the fractional part is the time. where .5 is midday, .0000 is midnight, etc

now the date-time number is displayed as either a date-only or as a date-and-time.  
so you might have dates with times in them, but you dont see it.

in some bizarre situations, these invisible fractional decimals can cause dates to behave oddly.

not sure how this would cause ALL your dates to show up a day early… but its worth checking.  
set the display of the date column to show both the date and time.  
it might give a clue to whats going wrong.

max

---

<div class="post-metadata">

**Author:** ![Elber\_Domingos1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/elber_domingos1/32/39356_2.png) [@Elber\_Domingos1](https://connect.superhuman.com/u/Elber_Domingos1)\
**Post date:** [December 7, 2023, 2:24pm UTC](https://connect.superhuman.com/t/calendar-showing-things-on-wrong-date/44857/3 "2023-12-07T14:24:05Z")

</div>

This is good to know. Thank you @Max_OBrien

---

<div class="post-metadata">

**Author:** ![Karen\_Kenjosian](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/karen_kenjosian/32/39311_2.png) [@Karen\_Kenjosian](https://connect.superhuman.com/u/Karen_Kenjosian)\
**Post date:** [December 7, 2023, 3:42pm UTC](https://connect.superhuman.com/t/calendar-showing-things-on-wrong-date/44857/4 "2023-12-07T15:42:37Z")

</div>

I figured out what was causing my instance of date mismanagement. I am in EST, but my work laptop is set to PT for my job. Changing the time zone option in coda has corrected the discrepancy.

Thank you for your replies.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [March 6, 2024, 3:43pm UTC](https://connect.superhuman.com/t/calendar-showing-things-on-wrong-date/44857/5 "2024-03-06T15:43:01Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
