use filter with concat value

[luigi.arena]

Hello,
I have a colum integer 20190102.

I have a lot record, I want to filter for this colum, example of data:
20120305
20150206
20190105
20200208

I want use filter for extract record where data is => current year, I try to use this expression but not working:
In filter compose I choose "Greater than or equal to"

Code: Select all

{Year(Date)+0101}

Can help me ?

[HighAley]

Hello.

There could be several solutions of your issue.

1. You could convert the date to string like this and comare with your data.

2. You could check just 4 first symbols/

3. You could convert the data to dates using an expression or a calculated column.

Thank you.