Help with getting data from database for 'today'

Hi there I have a tasks table and I am trying to get the list of tasks for “today”

I have tried to “round it down” which is what has been suggested though a different post and it didn’t work. I know the rest of the search works because when i remove the due date I get “3”

I think it may have something to do with time zone maybe… but any help would be greatly appreciated!

You need 2 constraints:

dueDate ≥ current date/time: rounded down to day

dueDate < current date/time: rounded down to day + days: 1

1 Like

This is everywhere in my apps.

You sir @adamhholmes are an absolute legend thank you soo much!!

My next question is how do I get data if the assignee or due date is empty. Any help would be amazing!!!

Hi Karl, have you tried to consult the bubble documentation? If you don’t want to read it, bubble bot is always available. He knows her perfectly and can support you easily without wasting your time. Go to bubble.io (you must be logged in) it appears after a few seconds at the bottom right. I hope it helps.

Yup I have tried both of these approaches but i’m not getting any responses

Why do you keep searching the nested database? Is it so necessary? I think the problem is there and this will cost you a bit of WU. I repeat. I recommend documentation, YouTube or the bubble bot.

This topic was automatically closed after 70 days. New replies are no longer allowed.