How to input multiple dates into a variable

[#1]

Hi,

       We have two list boxes with weekends. user wants to select 4 weekends for calendar1 for example(07/03,07/10,07/17,07/24) and 4 weeknds from the calendar2  and want to compare the sales amount.

thank you

[rahulgupta]

Use this:

vCalender1=getfieldselections(<fieldname1>,',')

vCalender2=getfieldselections(<fieldname2>,',')

Now in Expression:

Sum({<fieldname1={'$(vCalender1)'}>}Sales)

[#3]

thank yu Rahul. the variable part works well. but the sum amount is not .May be i am missing something.iam attaching the file.

[rahulgupta]

Hi!

I checked the file...the amount for weekend1 and for weekend2 are coming same that is y there difference is coming 0. so data is not being displayed in the chart.

[#5]

its not picking the different weekends form the list box.Ex. if we select week A and B in first listbox and Week C and D in the second listbox .its picking the same weekend in both the list boxes.

thank yu for yu help.