Every 1st day of the month, show the MTD report of the previous month. How do you do this?

[Former Member]

Currently this is what is happening

*On the 1st day of July,

It shows the sales of 1st of July.

As it is filtered by Current Month.

Month	MTD Sales
July	1

Requirement

On the 1st day of July,

the report has to show the MTD sales of the previous month.

Month	MTD Sales
June	1000

Is there function such as FirstDayofCurrentMonth?

I am thinking about creating a variable such as:

Variable = If (CurrentDate() = FirstDayofCurrentMonth)) Then (CurrentMonth()-1) Else (CurrentMonth())

Thanking you in advance...

[amitrathi239 · Accepted solution]

use this to get the first day on month.

=ToDate("01/"+FormatDate(CurrentDate();"MM/yyyy");"dd/MM/yyyy")

[Former Member · Accepted solution]

Thank you for this solution!!!!