selecting multiple dates on sheet activate

[#1]

I have a standalone list box that has the last four payperiods and need to select the same 4 payperiods in another list box that has a whole big list of pay periods because I need to restrict the dataset that I am displaying in one pivot in my application.

I am using this ='('&Concat(LastFourPayPeriods.PayPeriodEndDT,'|')&')'  to select in field on activate but it will not work, the output looks ok but it just will not select the values.

[#2]

Hi,

Try with this:

='("' & Concat(LastFourPayPeriods.PayPeriodEndDT,'"|"') & '")'

[Gysbert_Wassenaar · Accepted solution]

Maybe this works:

='('&Concat(distinct chr(34) & LastFourPayPeriods.PayPeriodEndDT & chr(34),'|')&')'

If not, you'll have to post more information. For example a sample document that demonstrates the problem.

[#4]

Thanks this worked for me 🙂