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

    Query - Incident NOT Updated within last 4 weeks

    lianne.redding Apprentice



      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,