directus: 11.0.0
have a date-only field (followup) and in UI I want to filter my collection to show records where the date is today.
My server’s timezone (TZ=Asia/Jerusalem) is set correctly, and dates display as expected in the UI. When I filter with$NOW, no records show up—even though there are records with today’s date. In the relative date display, it says “8 hours ago” (midnight in my timezone), so it seems $NOW compares the current timestamp to midnight, which doesn’t match.
Note: Manually selecting today’s date in the filter works fine.
Question: How can I reliably filter to show today’s records with a date-only field using$NOW or any other way?