Between in QlikView

[zagzebski]

I need to left join the F_Revenue table to the Dept_Activation table by the Dept field AND where the Service Date on the F_Revenue table is between the Active_Begin_Date and Active_End_Date. Looking for help on how to code the where clause to make this happen?

F_Revenue:

Dept,

Revenue,

Service Date

Resident Revenue

Left Join (F_Revenue)

Dept

Active_Begin_Date

Active_End_Date

Resident Dept

WHERE

Thanks,

Steve

[Clever_Anjos · Accepted solution]

Check your manual for INTERVALMATCH, is what you need

[zagzebski]

Thanks! Steve