Filter repeating table by year

[JanGoMak]

Hi all,

I am trying to figure out a way to filter the content in a repeating table by date that comes from a dropdown. I don’t want to use date pickers as I am just interested in the year.

I have tried various options, but never got it to work.

I am sure it is something rather simple, but I am not getting anywhere, so I would appreciate your help!

Warm regards,

Jan

[carlovsk.edits]

Hi my friend!

The first and simplest option is to have one column with the year number, for example 2025.

But if you need to use a date column you can try this:

I have one dropdown with a date list, specifically a list of years

This date list I generate with the expression element

Then I have one table with two columns: date and text

In my repeating group I show the text:

And in my search I use these constraints:

Taking the date greater or equal to the dropdown year (rounded down to year), and the other condition with the date less than the dropdown year (rounded down to year + one year).

This way you capture the dates within that year interval and can filter as you want.

Examples below:

2026

2025

2024

I hope this helps. God bless, and have a great weekend!

[JanGoMak]

Hi Carlo,

Thank you very much for your suggestion.
I found another solution that seems to be working:

I created two groups with the following info:

And then add the following constraints to the table: