2 Replies Latest reply: Mar 23, 2016 12:33 AM by Mayuresh Athalye RSS

    Sum between date range?

    Ian McDevitt

      I have a DOB field and want to do a sum on the amount of DOBs between dates.

       

      I have tried the following but it is not bringing back any results

       

      =Sum({[DOB]={"<$(=Date(Today()-1))>=$(=MonthStart(Today(),-3))"})

       

      and i wasn't sure if the date formats would be correct so also tried:

       

      =Sum( {$<[DOB]= {">=$(==Date(Today()-1))"}, [DOB]= {"<=$(=Date(Today(),-90)"} >} [DOB])

       

      but with no luck