Joint two tables with different date columns

[Richies]

Hi,

I have a table that includes different dates. Startdate and enddate. Say I want to show data having a certain startdate but also have the option to only show data with an endate within the same interval. Or lets say I want to show data with both the enddate and the startdate within the interval

I have a separate table with year, month, date and a #Datekey.

Question is how to join these to tables. 

If I join the two tables by using startdate as #Datekey I cannot see enddate in the selected inteval without going back to the script and change to join the tables by using endate as #Datekey instead.

There must be an easier way?

[Gysbert_Wassenaar]

You can use the intervalmatch function: https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

Or you can create reference dates for the intervals: https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944