3 Replies Latest reply: May 15, 2014 10:12 AM by donh _ RSS

    Creating "Week Of"

    donh _

      Hey all - - - working with a report that is run daily and need to create a report week field that is based off of the date of the report.  The week of report field needs to be dated Sundays.

       

      If the report has a report date of 1/19/2012 then the calculated report week column should read 1/15/2012

       

      Rpt Date          Rpt Day of Week     Rpt Week

                           

      1/19/2012          5 Thu          1/15/2012

      12/31/2007     2 Mon          12/30/2007

      1/1/2008          3 Tue          12/30/2007

      6/13/2005          2 Mon          6/12/2005

      /code

       

      I have to go back through several years of data - - - is there a way to do this without a lookup?

       

      Thanks

       

      Don