5 Replies Latest reply: Apr 10, 2017 12:09 PM by Sunny Talwar RSS

    sum between dates

    Eli Karp

      hi all,

       

      could someone assist with syntax here. I'm trying to sum between the beginning of year to the current date.

       

      Sum({<Date = {">=$(vYearStart) <=$(vToday)"} >} Field)  

       

      vYearStart= YearStart(Today()) 

      vToday =Date(Today())