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

    Count(if(  closed 0 and older then 7 days



      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!