2 Replies Latest reply: Apr 5, 2013 9:29 AM by Gysbert Wassenaar RSS

    Date intervals

      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...