I want to use Set Analysis to Link another date field based on already selected date values

[#1]

I have two tables, an invoice table and a loyalty points table.  Both have customer number and both have a date field.  The invoicedate links to the master calendar, but the loyaltydate does not.  I do not want to create a link table to link both the customer numbers and the dates.  What I would rather do is create a set analysis that whatever invoicedate is selected, I also select the exact same loyaltydate range.  I can use this in other situations involving dates as well.  We have a lot of tables and creating link tables gets cumbersome.

TIA

[Gysbert_Wassenaar]

I doubt that what you want can be done with set analysis. I think you should read this discussion: Master calendar. Pay particular attention to the posts of hic‌ and rwunderlich‌.

[Anonymous · Accepted solution]

This set should help you:

{<loyaltydate=P(invoicedate)>}

[ramoncova06]

Michael already gave you what I think is a good solution, though you are mentioning to selecting that range also, so do you want this in a listbox ? or you just want this in to be displayed in a table/graph ?

[#5]

Thank you very much, this was exactly what I needed!  This is going to make things a lot easier when I have dates in multiple tables that I want to be the same as the calendar selection.  Thank you

[#6]

The dates are a Year Month selection box and the totals are made in a table based on the selected dates.

Thank you for your interest in my situation.