2 Replies Latest reply: Sep 23, 2015 1:35 PM by g p RSS

    Unable to filter by Date

      Hi,

       

      I am trying to filter data by specific date. However, it ends up showing full set despite of $ in the front.

       

      I tried many different ways:

       

      SUM({$<[DATE(TRANSACTION_DATE,'MM/DD/YYYY')]=[DATE(TODAY(1),'MM/DD/YYYY')]>} QUANTITY)

       

      SUM({$<[INDAY(DATE(TRANSACTION_DATE,'MM/DD/YYYY'),DATE(TODAY(1),'MM/DD/YYYY'),0)]>} QUANTITY)

       

      It ends up showing full set unless I use Date filter.

       

      Please help.

       

      Thanks.