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

    Expression with date limitation

    Shamit Shah



      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?