# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## Month to Date Yesterday

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

1 Solution

Accepted Solutions
MVP

## Re: Month to Date Yesterday

May be this

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

2 Replies
MVP

## Re: Month to Date Yesterday

May be this

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

MVP

## Re: Month to Date Yesterday

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)