Page 1 of 1

How to filter by "days < 30"

Posted: Thu Jul 10, 2008 11:00 am
by 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


How to filter by "days < 30"

Posted: Thu Jul 10, 2008 1:30 pm
by 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.