2 Replies Latest reply: Jul 31, 2012 8:59 AM by harry_hhs RSS

    Count(if(  closed 0 and older then 7 days

      Hello,

       

      Probaly it's a small thing what i'm doing wrong, tried many combinations but aint getting te result i want.

       

       

      if ( IN_closed='0', Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) >= 7"} >} IN_number))
      

      Works, but i have to manualy select the IN_closed 0. (by selecting it in list box for example)

       

       

      count (if(IN_closed='0' , IN_number) )
      

       

      Works, but it shows all with condition IN_closed 0, i want only results shown wich are 7 days older.

       

      Can someone help me with this?

       

      Thanks in advance!