1 Reply Latest reply: May 31, 2011 11:04 AM by Piet Hein van der Stigchel RSS

    set analysis: use date functions and variables

      Hi,

       

      I would like to use set analysis to speed up my application in stead of if statements.

       

      count({< type={'CA','CC'} >} if(InMonth(ass_start_date,vReportingDate,0),assessmentId))

       

      How can i insert this if inside the set analysis? (only show  the records where the month of the start start is in the month of our reporting date). The reporting date is inside my variable.

       

      Thank you very much!