6 Replies Latest reply: Jun 6, 2016 12:10 AM by Shamit Shah RSS

    Expression with date limitation

    Shamit Shah

      Hi,

       

      I am trying to calculate the number of orders raised after the date today() -90 days and tried using the following expressions, but not getting any result:

       

      Count(Distinct {<OrderDate = { "<=date(today())-90,'DD-MM-YYYY'))" }>}PurchaseOrder)

       

      Count(Distinct {<OrderDate = { "<=date(today())-90))" }>}PurchaseOrder)

       

      Not sure what's incorrect in the above expression.

       

      Any ideas?

       

      Thanks

      Shamit