Looking up a range in the script

[danielact]

I have 2 tables I'm loading in a script. One has a bunch of dates for individual contracts - let's call the field ContractDate. The other table has a bunch of date ranges. It would look like this:

DateRange     StartDate     EndDate

1                    1/1/2011          2/5/2011

2                    2/6/2011          3/11/2011

3                    3/12/2011          3/31/2011

and so on. The two tables are not linked by any common fields. I want to look up the date on the first table and get the corresponding Date Range that the date falls into.

Any ideas on how to do that?

[CELAMBARASAN]

Hi,

     You mean one to one mapping?(first record to first record)

Celambarasan

[#3]

IntervalMatch()

[danielact]

This looks like the right function, but I can't get it to work... can you help me out with the syntax?

The date field in Table 1 is called ContractDate. I already entered the layout of Table 2 above.

[#5]

it could be: IntervalMatch ( ContractDate) Load StartDate, EndDate resident TableWithStartDateAndEndDateFields;

upload a reduced version of your QVW and I'll help you with it.

[danielact]

Here you go

[#7 · Accepted solution]

here you go, with just one final table.

[danielact]

Thanks a lot!

[#9]

Hi! i really want to see the syntex of the answer too.

but my Qlickview is personal edition so i cannot open this file,

can u please just copy  for me it in an answer???