Xano x Bubble -- Filter by Today's Date

raconcilo23

Help! I have tried to filter values that eual today's date and have tried almost every combination of > today's date rounded down to day +day -1 etc. and cannot figure it out.

How would you make this work in bubble?

Pawel Magdanski

You want filter this date in Bubble or Xano?

raconcilo23

@Pawel Magdanski - I want to filter the date in Bubble but xano is the backend

Pawel Magdanski

And what is the range of the dates that you are filtering through? A week, a month, longer than that?

raconcilo23

We will ultimaitely try to count the number of glasses of water drank today. So only today.

Pawel Magdanski

So what I would try is to make both the current date/time and the dates that you are formatting throught to be of the same format and then I would filter the exact date you are looking for. You can send dates from xano already formatted and then adjust current date/time format in Bubble to match it and use filter

raconcilo23

@Pawel Magdanski- Yes, I tried that and it still does not work. How would you use xano to format the incoming date to: YYYYMMDD? Perhaps that would work as I can equate the two numbers.

Pawel Magdanski

Something like d/m/Y I think. Can you post a screen from endpoint itself?

Apart from helping here I'm also helping people to go through blockers/issues via consultations. So you can drop me an email: pmagdanski@gmail.com and we can sort this and other issues if you have any out during regular session.

raconcilo23

Thanks! I figured it out. I can post from bubble in the format that I desire. :-)

Pawel Magdanski

Great, happy it worked!