I need to borrow your brains to think what possibly went wrong with my application.
I have multiple sheets in one application. Some of them only need the year selection to show the annual numbers. (eg. Ppl select 2013 to see 2013 numbers.) Others need to get down to the arbitrary date range selections. (eg. Ppl select 2013, Apr 21 as the StartDate and select 2013, Jun 20 as the EndDate to see the number of that date range)
I decided to create a list box of "Year" and an input box of "DayMonth" so they can use the "Year" list box only on the sheets that only "year" selection is required and they can use the "DayMonth" input box together with the "Year" list box on the other sheets.
Here is the steps I took to get this.
1. added a new field of "CalendarDayMonth"
2. created two variables: "VStartDayMonth" and "VEndDayMonth" and I made sure the formats match the "CalendarDayMonth" field.
3. put "Variable Event Triggers" to the variables, the action Field is "CalendarDayMonth", search String "='>=' & VStartDayMonth & '<='& VEndDayMonth
Now, I selected 2014 in the list box and input a date range in the "DayMonth" input box, it didn't trigger the "CalendarDayMonth" selection....:(
