Struggling with extract:date

Hello! I’m having trouble with extract:date.


I have a data type of reminder, which has a date and an option set for repeating, including Daily, weekly, monthly, and yearly. In a repeating group, I have a list of reminders where repeat interval is monthly filtered by this reminders date: extract date is equal to date/time picker calendar’s date extract date.

So, for example, I have a monthly recurring reminder on 11/6, but when date picker is set to 12/6 it doesn’t show the reminder. Shouldn’t the filter formula work like this: 11/6 extract: date =6 and date/time picker calendar 12/6 extract:date = 6 to show it?

It similarly doesn’t work for the yearly reminders, but it works for daily and weekly reminders. Can anyone explain my error?