I have seen a number of ticket aging requests, and there was some good information in there, but I have so far not been able to find something that would help with my specific needs.
We have a report which contains some member information, including the date the date received. We would like to have a separate column which would express the ticket aging, in 30, 60, and 90 day intervals.
In this case, however, we do not want the aging to be from the date received, we would like the aging to be from the 1st of the month of the date received. So if the line is dated 2/27/2011, and it is now 3/1/2011, the record should be marked as being 30 days old.
I have attached a spreadsheet which will hopefully explain what I am talking about better.
Additionally, if there is a way that the entore row can change the background color based on this aging value, that would be great as well.
Thank you.
Daniel
Bookmarks