3 Replies Latest reply: Jul 7, 2011 7:56 AM by Miguel Angel Baeyens de Arce RSS

    Set analysis - urgent question

    Rajesh Vaswani

      Hi,

           I have a expression like below

       

      =Count({<[link_claim_Claim_Status]={'CLO'},[End Date] ={'>=$(=Date(only(varPreYearFullDateStart)<=$(=Date(varPreYearFullDateEnd))'}>} DISTINCT [ClaimID])

       

      For now I have hardcoded the start and end dates in the variables

       

      varPreYearFullDateStart=Num(Date('01/01/2010','dd/MM/YYYY'))

       

      varPreYearFullDateEnd=Num(Date('31/12/2010','dd/MM/YYYY'))

       

      The result i get somehow is not taking the date in between intervals.

       

      Could someone kindly help me where I am going wrong?

       

      Thanks in advance

       

      Rajesh Vaswani