This content has been marked as final. Show 3 replies
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
I have to go back through several years of data - - - is there a way to do this without a lookup?