Filter for the data on the previous month

[harson]

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.

[sunny_talwar · Accepted solution]

May be use this for Year

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