Dynamic filter in Nprinting by month

[#1]

Hello All,

I need to create a filter in Nprinting to select the last 3 months.

To calculate the current month I am using the below expression:

=Month(now()) which returns the value June.

However, I do not get any value using =Month(now()-1) and when I try this expression =Month(now())-1 it gives me 5 as the result.

I need an expression which will return the value of May and April.

Any idea?

Many Thanks,

Hasvine

[Daniel_Jenkins · Accepted solution]

Hi Hasvine,

For May & April try:

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

&

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

HTH - Daniel.

[#3]

Hi Daniel,

Thank you for your help.

You are the best.

Thanks,

Hasvine

[paolakamdem]

hello,

i have tried this but it continues to give me another thing.

do you have another solution please?