Hello!
I am trying to build what I thought was a simple report to list demands that have not been updated in over 120 days. I am pulling demands that are not closed and the date in the Updated field is before 120 days.
As I was reviewing the output I noticed that one of the demands that was returned has demand tasks that were closed within the past week. I guess that updating the demand task does not also update the Updated field on the demand.
I am having difficulties trying to build the report to also look at all the demand tasks because, if a demand task is updated, I feel that should count as the demand being updated. It reflects that someone is doing something related to the demand and it is not sitting idle.
Any ideas?
