1 Reply Latest reply: Jan 2, 2014 1:02 PM by Srini VEERAVALLI RSS

    TODATE function

    UOOLK

      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.