I am trying to have my document automatically select the max calendar year on open. I am trying to use document triggers to accomplish this. My first trigger is a Clear All. The next trigger is: =max(CalendarYear). Please see screenshot below.
The problem is that I only get the correct max year if no year was selected in the prior save. Otherwise, the year will show up as the one last saved despite the Clear All trigger and the Select in Field trigger.
Can anyone please help? Is this a bug?
Message was edited by: Alexander Grando
Reason: Attached sample app.
I actually already have a single field that I can use to get the max date. But the reason I want to do one separately for year and another for month is to bring attention to the listboxes via the the green highlight color. Otherwise, they are only colored white if indirectly selected. Please have a look at my app above if you want.