5 Replies Latest reply: Nov 4, 2015 4:02 PM by ANDY SALLEE RSS

    Sum Value based upon date time

    ANDY SALLEE

      Hello,

       

      I am working to get a sum based upon a date time field. I would like to sum value of field it day is equal to current date or previous date.

       

      this is the formula currently have and just get the sum for all days, sure have some sytanx off slightly.

       

      Sum({$<[Date(TicketDate)]={[today()]}>}BblsQuantity)

       

      Thanks

       

      Andy