Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Apr 21, 2020 5:06 pm**

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 ?

Posted: **Tue Apr 21, 2020 9:13 pm**

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.

Creating reports and dashboards | Stimulsoft community forum

use filter with concat value

use filter with concat value

Re: use filter with concat value