App Development

[shayd]

Hi all,

I have a table holding only dimensions, no measures.
I wish to filter the table via a date field so only 2021 will show up using aggr & only (since I cant use set analysis).
The date field looks like this: dd/mm/yyyy
I've tried using  =aggr(only({<num(year(Date))={num(year(today()))}>}Date), Date)  to extract the year but all I get is nulls.

Any suggestions?
Thanks!

[Gysbert_Wassenaar]

Why not simple select this years dates?

[shayd]

That's what I've been asked.
The table should show only certain year.
Basically I've succeeded in doing this using "if" but I wish to see if there is another option.