I am in need of brain picking.
I need total Amount aggregated over last quarter but excludes the last 7 days .
Consider this is quarter-3 Oct 1 to Dec 31 2013 and today is 21st december 2013( assume)
what i need is a function/ workaround which will give me the amount for current quarter but stops 1 week short of current date ( or less 7 days from current date) .i.e
i.e it should total amount upto 14th December 2013 from 1 st october 2013.
Check this link you might get some idea http://www.cool-bi.com/Tweaks/DateExcludingWeekends.php
first try to get that last week date ie 14th Dec by validating the current day with Saturday and then look back for 7 days