Current month and two previous months

[stekol61]

Hi!

I have an OnOpen trigger as "=Num(Month(Today()), '00')".

This gets the current month when the report id opened.

I want to have current month and the previous 2 months instead, e.g. Sep, Aug and July

How to do this?

[tresesco]

May be this:

='(' & Num(Month(Today()), '00') &'|'& Num(Month(Today())-1, '00') & ')'

[antoniotiman]

Hi Stefan,

try this

='>='&Num(Month(AddMonths(Today(),-2)))&'<='&Num(Month(Today()))

Regards,

Antonio

[stekol61]

This works fine.

Thank You