I have a date that I am using to filter a collection, and getting inconsistent results. I have the date picker fetch the collection on change and I’m finding that when I change the date around sometimes I get no results when I should. I tried copying the filters to supabase and I got the expected result. I tried fetching the collection received nothing fetched again and got the expected result?
I’d need to see the setup in detail to debug this 
Sure. on change of the date picker this is the workflow,
There are 2 filters on the load collection, one for date > datepicker - value and date < addDays(datepicker - value,1). which return values like “2024-02-01T13:00:00.074Z” and “2024-02-02T13:00:00.742Z”
The date field in supabase is a timestampz feild and when I filter to test in supabase it has always returned the expected result.
The repeated group just has the load collection in it at this stage.
I have a few other filters that I would like to add but I have simplified it to this setup for now. Let me know if there’s any extra information that would be helpful.
My best guess would be something’s up with the dates on front-end. Is it the same format? I know dates can be hella tricky.
yeah, when I’m testing the filter on the backend I have just copied what the result is from the date picker so it should be exactly the same.