6 Replies Latest reply: Nov 30, 2010 4:15 PM by Yury Pritzker RSS

    date ranges

    Yury Pritzker

       

      I have a table with products that has START_DATE and END_DATE fields. I also have many other related tables with the same START_DATE and END_DATE. I need to have an ability to filter and count my items depending on a specific Year and a specific Quarter. I am thinking to have in inline table that would identifies Years and Quarter(how?) and then link it somehow (how?) to the real tables. But I need to know that a chosen Year is inside of the range between START_DATE and END_DATE. Any Ideas how to do that?

      Thanks a lot.