Date interval Issue

[#1]

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

[#2]

hi

try this

if(From>To,null(),
only({<Date={'>=$(=Date(From))<=$(=Date(To))'}>} Date))