10 Replies Latest reply: Apr 28, 2014 5:22 AM by Murti Akkime RSS

    Using rolling dates and setting them as variables

      Hello !

      I'm trying to figure out the sales for each of my clients in the last 90, 180, 365 days. I'd like to store the sales in those time-frames as variables.

      I was trying something like: sum($<{Orderdate >= today()-365, Orderdate <= today()} $(vSales)) but to no avail...

      Thanks a lot in advance !!!