Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On opening a sheet i would like to force Feb, Mar,Apr,May to trigger for 2014.
I can trigger a variable for VCurrentYear and vCurrentMonth.
How do i expand this to be the next 4 inclusive.?
thanks
Hi Tim,
use a formula, like
>>> ([month_field] >= v_current_month AND [month_field] <= (v_current_month + 3)) <<<
set vCurrentMonth = ("Feb"|"Mar"|"Apr"|"May")
Use select in field on your date field and use this as the search string:
='>=' & MonthStart(Today()) & '<=' & MonthEnd(AddMonths(Today(), 3))
In document properties on the triggers tab you can add this as a on open trigger.