Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Sum({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=Date(Today()-1))'}>}Sales)
May be this
Sum({$<Date = {'>=$(=MonthStart(Today()-1))<=$(=Date(Today()-1))'}>}Sales)
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)