2 Replies Latest reply: Sep 25, 2017 11:36 AM by Anand Chouhan RSS

    Month to Date Yesterday

    Chris Jackson

      Hi

       

      I'm trying to use a MonthToDate formula but only include up to yesterday. I thought this would be easy using the formula below, but it includes transactions from today as well. Is there something obviously wrong with the formula?

       

      SUM({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=MonthEnd(Today()-1))'}>}Sales)

       

      Thanks