3 Replies Latest reply on Feb 9, 2010 8:01 AM by lianne.redding

    Query - Incident NOT Updated within last 4 weeks

    Apprentice

      Hi,

       

      I'm trying to write a query in ITBM 73 to list all incidents that are open and that haven't been updated within the last 4 weeks.  There's the option to choose the condition 'Is within the previous' but I need is not within the previous.

       

      I have written it in SQL but I need to put it on a dashboard so need to achieve it in the product.

       

      Has anyone managed to come up with a way of adding a condition like this to their query?

       

      Many thanks,

      Lianne.