Month to Date Yesterday

[chrisjackson]

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

[sunny_talwar · Accepted solution]

May be this

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

[its_anandrjs]

It is absolutely correct

and why not only use today()

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

Or

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