I'm wondering what the best way is to create and array where a user can select or de-select multiple dates before submitting a query. I already have a calendar that can detect which date is selected / de-selected.
The variable "DateSerial(intYear, intMonth, DayIndex)" is receives a value each time a date is clicked on.
I've created a public array "queryDate(1 to 50)" for the days they might want to select(up to 50 days). The question I have is what's the best way to manage the array as the user clicks on or clicks off dates before submitting the calendar? How do I sort and include/exclude dates in the array as the user clicks and unclicks dates? (Ideally I'd like to have them just add by clicking, but I have to plan for user error when they need to uncheck the wrong date).