Bug: Calendar collection is missing data for specific month

Team ID:
6y6NqmQiEH09Vv47WNPg

App ID:
8AGfreik5AcFOkajhAeF

Description:
September events are not showing in the app, while August events are displaying normally. I believe this may be a bug related to Glide. I need help understanding why the September data is not appearing and whether there is a known issue or configuration problem causing this behavior.

You can see a video of the bug here

How to replicate:

  1. Open the app.
  2. Navigate to the events section.
  3. Compare the displayed events for August and September.
  4. Notice that August events appear correctly, but September events do not show up.

Additional details:

  • August events are visible.
  • September events are missing.
  • I have not intentionally changed anything that should hide the September events.
  • Please let me know if you need screenshots, table structure, or more details.

You can see a video of the bug here

Do you have any August events between August 1st and August 12th that should be showing up? Do you have any September events after September 12th? How are the dates being entered into the table? How do you commonly read and write dates?

I do, i have dates for almost everyday from aug 12 to end of september

I did find a solution but like everything with glide, a weird one.

Im attaching you a screenshot with 3 date columns

2 of them doesnt work god knows why, only 1 works, eventhough they are all exactly the same

My first suspicion would be that day and month are getting mixed up and some events are ending up in different months, but based on what I see in your video, I would expect something like rhe September 16th event to work correctly.

I wouldn’t have a lot of faith in the formatted date column working, especially since you are formatting in DD/MM/YYYY format. As for the other two, I can’t really tell what’s different between them. That’s why I asked how the dates are being filled. It’s that underlying value that is a lot more important than the formatted version you see in the data editor. I think you are safer if the dates come from a date picker, but if they come from an external source, then it can be a lot harder for code to differentiate DDMMYYY vs MMDDYYYY.

That said, I don’t think glide has ever done a great job handling dates as people have fought with it for years.