5 Replies Latest reply: Dec 4, 2012 1:25 PM by steve peroni RSS

    calculated date

    steve peroni

      Dear all,

      I'm trying to calculate two dates starting from the selected date, but I'm making some mistakes.


      I've a list box with the operation date

      Choosing a date, I would display into a graph, the total operations for the selected date, the total operation for 7 days ago and two weeks ago, like this:



      Nr.Operation for select.date         Nr.operat.                              Nr. operat.

      30 november 2012                      23 nov 2012                         16 nov 2012

                100                                        110                                        90


      I tried the following:


      count({<Operation_DATE={$(=only((date(num(getfieldselections(Operation_DATE))-7))))}>} OperationID)


      but it doesn't work, it doesn't recognize the calculated date


      Help please


      Thanks in advance