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.