You need to use this created date or opened date - now() > 60 use formula return type number.
Simple create field 1 to find out no of days passed say created date - now()
Use this in new formula say No days passed > 30 then
I don't know if this is useful, but this is a report I did using a bucket field showing how long it took to close tickets. Might be able to do something similar for what you are looking for.
I will post an example here today
You can actually do this in the report itself if you would like. You would just have to add the filter logic on each report to only show records that are Greater than 30 but less than 60 days. I have attached a screenshot that may help. You would have to have 3 different reports that would show the different filter criteria to get this.
Hope this helps.
Eric J Cobb
This the what I had to set up for the formal field to get it to work.
IF ( NOT(ISNULL(BMCServiceDesk__closeDateTime__c)),
BMCServiceDesk__closeDateTime__c - BMCServiceDesk__openDateTime__c,
NOW() - (BMCServiceDesk__openDateTime__c ))
Just want to thank everyone for their help