How to filter by "days < 30"

[Sandy Pham]

I have a customer that wants to create a report with different data bands that show Incidents open less than 30 days, between 30 and 60 days, and greater than 60 days.

I thought we could add a filter to the databand to do something like this, but it does not work:

{DateTime.Now.Subtract(Incident.Created_Date_Time).TotalDays} < 30

[Edward]

Hello, Sandy.

Yes, it is possible to resolve.

Please modify the expression inside the filter as follows:

Code: Select all

DateTime.Now.Subtract(Incident.Created_Date_Time).TotalDays < 30

Thank you.