Filter for the data on the previous month

harson — Wed, 25 Nov 2020 16:16:04 GMT

Hello Community

I encountered a difficulty on a filter in NPrinting.

I have to retrieve the previous month's data, and I put as filter :

Month=Month(AddMonths(Now(), - 1)),

Year=Year(Now()).

The problem is that if I am in January and I have to retrieve the data from December, it did not work.

Any ideas ?

Thanks in advance.

Re: Filter for the data on the previous month

sunny_talwar — Mon, 20 Mar 2017 11:44:51 GMT

May be use this for Year

Year=Year(AddMonths(Now(), - 1))