Date intervals

[#1]

Friends! On the agenda I was overtaken by the following task:

I has a table with the SALE DATE field which contains sale date. also there is a table with PRICING DATE field which contains from 2 to 10 dates and each date corresponds му the price. Okay. And the task washing consists what to select actual date of pricing, i.e. to understand how my date of sale gets to what interval of dates (from 10 dates of pricing for example).

SALE DATE              PRICING DATE

01.01.2012                30.09.2011

02.02.2012                31.12.2011

                                  01.02.2012

                                  02.04.2012

Help me to apply the intervalmatch() function or perhaps there is an alternative solution of this task...

Thnx...

[#2]

I.e. from a set of all dates to select the upper and lower dates which most lie to sale date closer.

[Gysbert_Wassenaar]

Try this first instead of using intervalmatch