Trigger on date functions.

[#1]

I have expense Month-Year as below.I want to add a trigger to default to the rolling months period.

When I land on a page the trigger should default the Month-Yr from Aug - 2017 to June - 2018.How can I do that ?

Thanks much.

[sunny_talwar]

I guess add a sheet level trigger like this:

='>=' & Date(MakeDate(2017, 8, 1), 'MMM-YYYY') & '<=' & Date(MakeDate(2018, 6, 1), 'MMM-YYYY')

This is assuming that Expense Month-Year is created like this in the script:

Date(MonthStart(DateField), 'MMM-YYYY') as [Expense Month-Year]

[#3]

yup...this is how I have the Month-year created but if I use (2017,8,1) every month I have to manually change it every month right ? Is there any way I can automate that ?

[sunny_talwar]

What is the logic for choosing August 1st 2017 and June 1st 2018?

[maxgro]

change the bold as your requirement

='>=' & Date(AddMonths(Today(),0), 'MMM-YYYY') & '<=' & Date(AddMonths(Today(),11), 'MMM-YYYY')

[sunny_talwar]

But maxgro‌ today is 2016, I think with this logic, he might need this:

='>=' & Date(AddMonths(Today(), 12), 'MMM-YYYY') & '<=' & Date(AddMonths(Today(), 23), 'MMM-YYYY')