2 Replies Latest reply: Jul 23, 2013 8:45 AM by Mohit Sharma RSS

    Sum between date in table

    Luca Marasi

      Good morning all,

       

      Can someone please help me with some syntax?

       

      I have two fields named StartDate and EndDate and I need to sum the total amount of Value that falls into them and the selection in dates.

       

       

      I try this

       

      Sum( {$<Date = {“>=$(=Only(StartDate))<=$(=Only(EndDate))”} >} InvoiceAmount)

       

      But this doesn't work in my table.

       

      dim 1startdateenddate

      Sum( {$<Date = {“>=$(=Only(StartDate))<=$(=Only(EndDate))”} >} InvoiceAmount)


       

      Only(Startdate)
      A117/01/201331/12/2013-17/01/2013
      A218/02/201331/12/2014-18/02/2013






       

      I need to select the year, for example 2013, but i want that my expression show the amount starting at 17/01/13 for first row and at 18/02/2013 for second row.

       

      Can anyone help me, please?

       

      Bye