I have an input box where the user enters the reporting year month i.e. YYYYMM format or user can select from the drop down list that has listed values from 200801, 200802, 200803....... 201012.
Is there a way to automate this i.e. the drop down list will show 2 years back and current year without having to update this list every year?
I tried creating an island table just to store the periods and show it on multibox; and assign the variable with this value that the user selects. However, my user also wants the flexibility of entering just like the input box. Any idea?
Maybe in the list box you can use the expression: =If(Year(Today())-Year(dateField)<=2 , dateField) That'll show you the 2 years back. If you want it to work with the input box too, I think you can add an "if" clause in the beginning of the expression validating if the input box is empty or not. If the input box is empty (the user didn't enter a value) then 2 years back expression will evaluated.
