1 Reply Latest reply on Jan 2, 2014 7:02 PM by SriniVEERAVALLI

    TODATE function


      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.