How to Select the next 4 months

[timsaddler]

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

[datanibbler]

Hi Tim,

use a formula, like

>>> ([month_field] >= v_current_month AND [month_field] <= (v_current_month + 3)) <<<

[manojkulkarni]

set vCurrentMonth = ("Feb"|"Mar"|"Apr"|"May")

[jpapador]

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.