1 Reply Latest reply: Jan 29, 2013 12:47 AM by Vishwaranjan Kumar RSS

    Date interval Issue

    Angad Singh

      Hello Everyone,

       

      I am into a situation wherein I need some help from the community. My requirement is that when I select Month and Year from the Calendar created, suppose Sep 2012, then it must start with 09/30/12 (last date of month) trades and go back in time in 10 day periods to look at the data over the past four months of trades.

       

      Expected Result :

      Trade-in Date
      6/2/2012 - 6/11/2012
      6/12/2012 - 6/21/2012
      6/22/2012 - 7/1/2012
      7/2/2012 - 7/11/2012
      7/12/2012 - 7/21/2012
      7/22/2012 - 7/31/2012
      8/1/2012 - 8/10/2012
      8/11/2012 - 8/20/2012
      8/21/2012 - 8/30/2012
      8/31/2012 - 9/9/2012
      9/10/2012 - 9/19/2012
      9/20/2012 - 9/30/2012

       

      Thanks