Filter to exclude current months data

[podge2019]

Hello,

New to NPrinting so for some this should hopefully be quiet easy.

Looking to apply a filter that will exclude my current months data in a report and just give me the last two months. i.e. exclude this month (May) and just give April and March.

Formula I am currently using  below (thanks to @Lech_Miszkiewicz NPrinting Adventures Blog) gives me May, April, March.

Advanced Search =([Date]>MonthStart(Today(),-2))*([Date]<=Today())

Would someone be able to advise how the above would be amended to exclude this current month.

Many Thanks in Advance.

[sunny_talwar]

May be this

=([Date]>MonthStart(Today(),-2))*([Date]<MonthStart(Today()))

[podge2019]

Thanks for the quick reply Sunny @sunny_talwar ,

Unfortunately 

=([Date]>MonthStart(Today(),-2))*([Date]<MonthStart(Today()))

 still brings in the three months data.

It does not exclude the current month.

[sunny_talwar]

How about this

=[Date] > MonthStart(Today(), -2) and [Date] < MonthStart(Today())

[podge2019]

Hi Sunny, @sunny_talwar 

No change also with:

=[Date] > MonthStart(Today(), -2) and [Date] < MonthStart(Today())

Still bringing in this months data.

Is there any more information I could provide that may assist?

Thanks again.

[sunny_talwar]

Can you try out few things. What do you get when you use just this

=[Date] < MonthStart(Today())

Do you get all months before May? or do you still get May? How about when you use this

=[Date] <= (MonthStart(Today())-1)

[podge2019]

Hi Sunny, @sunny_talwar 

When I used: =[Date] < MonthStart(Today())

I get all data that is loaded so it goes back to Jan 2017 up to and including May 2020.

When I use: =[Date] <= (MonthStart(Today())-1)

I get the same - Jan 2017 up to and including May 2020.

Regards

[sunny_talwar]

Sorry, can you try one more thing for me... what do you get when you use this

=[Date] < MonthStart(Today(), -1)

Anything different? Also, does spaces make a difference?

=[Date]<MonthStart(Today(), -1)
=[Date]<MonthStart(Today())

[podge2019]

Happy to try @sunny_talwar 

=[Date] < MonthStart(Today(), -1)

This bring in all the data from Jan 2017 to April 2020, however, it then doesn't populate the data in April 2020.

Does exclude May 2020 though which is progress so the spaces make a difference.

[sunny_talwar]

Is April 2020 included or not included? I am not sure I understand