Link record based on date from and date till

[tedjansen]

Hi,

I have two tables, containing hourly wages and the hours worked. 
The table containing the hourly wages is built as following:

Every employee has a record (or multiple) with a starting date and a date that that salary ends. 

And the hours worked is built as followed:

I need to calculate the approximate wage by multiplying the Amount and HourlyRate + WORNomal + WORExtra. This is working right now, but not date independent.

How can i make a formula that takes the date of the worked hours (for example 01-06-2019) and looks up the salary that is connected to it (salary is from 01-01-2019 to 31-07-2019)?

Thanks

[sunny_talwar]

Check here IntervalMatch (Extended Syntax)