Filterbykey possible with math equation?

[thijs]

Hi,

I’d like to create a dynamic list of a dynamic collection with a simple split based on a date of a record:

• Group 1: all records with date older than today
• Group 2: all records with date newer than today

Within these groups I can create a second list with a FILTERBYKEY(COLLECTION,DATE,???) ← how can I have this (or another) formula filter based on an equation (higher/lower than value X) instead of a fixed value?

Thanks!
Thijs

[sam1]

you can use the filtering in the image to do that, but I don’t think you can with filter by key personally I have opted to use js where I have needed to do that