5 Replies Latest reply: Nov 22, 2017 8:08 AM by Sunny Talwar RSS

    Set Analysis

    Avinash S

      Hi Team,

       

      Need Help. I am trying to extract total transaction between a defined date range. But i am not getting it.

       

      For example Start date=5-Nov-2017

      Start date=12-Nov-2017

       

      For this i have tried writing the set analysis but it's not correct.

       

      set vStartDate= date#('05/11/2017','DD/MM/YYYY')

      set vEndDate= date#('05/11/2017','DD/MM/YYYY')

       

      count({<TransactionDateTime={">=$(vStartDate)<=$(vEndDate)"}>} distinct TransactionSlip)

       

      Can some help me in correcting it.

       

      Regards,

      Avinash