This content has been marked as final. Show 2 replies
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
Help me to apply the intervalmatch() function or perhaps there is an alternative solution of this task...