13 Replies Latest reply: Aug 31, 2012 9:43 AM by Gerhard Laubscher RSS

    Use Yesterday in expression

    Gerhard Laubscher

      Hi,

       

      please help me with this expression - cannot get it right:

       

      Count({<[Posted Date]={"=date(today()-1)"}>} [Trans Amount])

       

      I want to count the number of transactions that have a Posted Date of Yesterday.

       

       

      Thanks in advance,

       

      Gerhard