# Relations only working for previous days **URL:** \ **Category:** Ask for Help\ **Created:** [October 29, 2025, 1:25pm UTC](https://community.glideapps.com/t/relations-only-working-for-previous-days/85130 "2025-10-29T13:25:36Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Abbie\_Phillips-Jones](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abbie_phillips-jones/32/83354_2.png) [@Abbie\_Phillips-Jones](https://community.glideapps.com/u/Abbie_Phillips-Jones)\ **Post date:** [October 29, 2025, 1:25pm UTC](https://community.glideapps.com/t/relations-only-working-for-previous-days/85130/1 "2025-10-29T13:25:36Z")
Hi, I am trying to build an app to log daily energy levels. It will be a to-do list / task management app where a task is assigned an energy level based on whether it increases or decreases the daily total. e.g. I start my day with 50 energy points. I read a book which is +10 but then I have to do the laundry which is -5. I would then have a daily summary page where I can see how much energy is left on that day. Here is the current data table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/148ca771111a6c082203331b824dd1e123716e5b.png) I then have a summary table: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0efbae5c6d7d777b21397cb8cf1244a398a16fae.png) This all seems to work but where I am getting stuck is that I can add a new task manually to the Task table and it will also appear in the summary table. However, when I add a task via the app, it will add it to both tables IF the date is for a previous day. However if the task is for the same day as today it does not show: Here is my workflow for the add task button (I had read that this seems to be less ‘buggy’ than the default one) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2dd316ff3a5d53601f257d8abea87ed78f536e9c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0635c3b437f4c95c2ba4f0a100c1ee238abfb7f.png) And here is the task showing in both tables ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e7c9396738287bf52b5cd9c562a3d9a9bd354c8.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d41247b99a84c73aac396e2ab75b96b0bca83c79.png) However, if I now do exactly the same process but the date is the 29/10/2025 (todays date), the task is not showing in the Task relation of the summary table. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/353f2a56fc15570a7de2d9800d3cdc9b8d12cfdf.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55450efe5d635c8f42523d61cab1a9d6f5272c8e.png) I have been at this for hours trying all manner of suggestions (admittedly chat gpt). Which suggest using math columns to format the date which I have tried but this didn’t seem to work (so I have not created everything again from scratch). Any suggestions would be greatly appreciated. Thank you ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 29, 2025, 8:55pm UTC](https://community.glideapps.com/t/relations-only-working-for-previous-days/85130/2 "2025-10-29T20:55:25Z")
I believe the issue here is that the date isn’t truly matching. You said you attempted to use the math column to format the date into numbers. That’s what I would try as well. I use this formula before making the relation: `year(date)*10000+month(date)*100+day(date)` If you double click those dates inside of the date column, what do you notice? Do they have a time attached to them like midnight or noon? If you can’t figure it out, DM me, and we can troubleshoot from there.