Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
try this
if(From>To,null(),
only({<Date={'>=$(=Date(From))<=$(=Date(To))'}>} Date))