Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this:
='(' & Num(Month(Today()), '00') &'|'& Num(Month(Today())-1, '00') & ')'
Hi Stefan,
try this
='>='&Num(Month(AddMonths(Today(),-2)))&'<='&Num(Month(Today()))
Regards,
Antonio
This works fine.
Thank You