Calendar Collection adding entry on the next day

Hi all,

I’m currently building a simple rostering app and am having an issue where when i add a new “shift” in the calendar, it is being added to the date after i selected. For example, if i add an entry to the 17th Nov, it would appear on the 18th of Nov. Have refreshed a few times assuming it might be a bug or something but thought i’d check in and see if anyone else has had this issue before.


My initial thought is that it probably has something to do with time zones.
What are you using as a data source for your App?

Just using a Glide Table for this one.
Have tried with ‘respect timezones’ on & off with no luck.

If you click into your Start and End columns, you should find that the underlying value also includes a date. Does that provide a clue?

Screen Shot 2022-11-17 at 6.08.32 PM

My suggestion would be to use two columns instead of three. One each for the Shift Start and Shift End time, and format both columns as date/time.

1 Like

The start and end are not including a real date… is just hours… which will be a problem to relate to… and no name in there too…

when you are recording an event… it should have full-time, and unique ID