Independent date picker that will still filter selections

[#1]

I am trying to create a date picker that allows me to pick any date but also filter my list boxes by that date.

I set a variable called vSelectedDay to set the date.   The range for my dates are min/max(Date(ProcessDate).

I have a List Box that show Salespeople.   I want that list box to filter all those salespeople that have sales on the ProcessDate.

If I do a trigger to on the vSelectedDay variable to "Select in Field - ProcessDate=vSelectedDay", my Salesperson list filters fine.

The problem is that my DatePicker now is stuck on the Selected Day until I do a "Clear Selections".

My app is large and complicated, so it is hard to upload but I can provide Screenshots if that does not make sense.

[Qrishna]

post a demo document with some sample data.

Thanks

[#3]

Report in question is the First report - Daily Sales

Right now i have triggers set on the Sheet Open properties to Select in Field - Date_ProcessDate = vDate_Selected.

vDate_Selected is originally set by my script to max(Date_ProcessDate)

I then have triggers on the variable vSelectedDay to set Select in Field - Date_ProcessDate = vDate_Selected.