Get Multiple dates using GetSelectedCount in filter pane

[vsap2000]

Hello Guys,

I have a set expression which brings single date in a filter pane from below formula:

Aggr(Only({<Order_No={$(=if(GetSelectedCount(Order_No) > 0,concat({$} chr(39)&Order_No&chr(39),',')))}>} CustIssue_dt), CustIssue_dt)

Is there a way to bring multiple dates.

For example: a single Order_No = A001 brings CustIssue_Dt = 12/20/2024 in the filter pane. Is there any way I can bring all the dates which are 3 days ahead and 3 days later but these dates should not fall on weekends. It should show in filter pane 12/17,12/18,12/19,12/20,12/23,12/24,12/25.

Beside showing in filter pane can it be applied automatically instead of selecting the dates.

If there is a different method also please let me know.

Thanks,

-V

[Anil_Babu_Samineni]

If you can share sample application with dataset, That might be best such cases.