Set Analysis Selecting fields

[#1]

Hi All,

In the attached file i have two listboxes, one is "current Year" and another is "Comparison".

All i need is if user select a date from from current year listbox a date in comparisin year list box should not get selected.

I search the whole community but i can't sort it out. Could some one help me to sorted this out.

Thanks in advance!

[alexandros17]

THe dates works on the same field (Date1) so if you select a value in a field this value will be showned in all the objects, in my opinion you need another date field to compare ... try to join or associate another calendar table

Hope it helps