Relations only working for previous days

[Abbie_Phillips-Jones]

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

I then have a summary table:

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)

And here is the task showing in both tables

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.

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

[Robert_Petitto]

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.