Date Trigger

[apthansh]

[Month of Expense] >= monthname(today()) and [Month of Expense] <= monthname(AddMonths(today() ,11))

How do I put the above in sheet trigger ?

Thanks much.

[#2]

Go to Sheet Properties, place your expression to show/hide sheet in Conditional textbox

[apthansh]

Thank you.

But I meant how to writ that Script in condition ? I think it needs a different format.

[#4]

Declare two variables and use them in expression 

vMonthToday = monthname(today());
vMonthAddMonths = monthname(AddMonths(today() ,11));

if([Month of Expense] >= $(vMonthToday)  and [Month of Expense] <= $(vMonthAddMonths))

[apthansh]

Thank you...but I want to put it in Trigger condition ..so I gave as below

Field : [Month of Expense]

Search String : = '>=' & $(vMonthToday)  and '<=' & $(vMonthAddMonths)

Doesnt look like it is working...

Month of expense is in below format

Nov 2016

Thanks much