What I want to do is filter by ‘Date’ that is specified by the user, instead of ‘Update Date’ which means when the record is created.
Let’s say I recorded the one week ago’s rating today, ‘Update Date’ is ‘today’, but the record has ‘Date’ property of ‘one week ago’, and I want to use ‘Date’ property to filter.
If that is the case, you would need to add another date field which is updated according to your own formula, you can add as many date fields as you need and update them before applying the filter.
Partially solved. I found I should change the database structure simpler.
(Looks like the filter does not work as I wanted if three collections are involved.)