6 Replies Latest reply: May 14, 2013 3:28 AM by Mohit Sharma RSS

    Not able to filter the data

      =if(PROGRAM_ID <> if(EVT_DATE <= '4/30/2013' and EVT_DATE >='4/1/2013',PROGRAM_ID),PROGRAM_ID)

       

      in the above expression i want to filter the program id where transaction has not taken place in last month.. please someone help its urgent.