You ever wanted to create a status report view, that gives you all the “events” that happened last week? Look no further !
For each event that you want to limit to last week’s data, let’s go with “modified” for now, create two new fields:
ModifiedReportStart
Make it a calculated field, and give it the formula:
=Modified+7-WEEKDAY(Modified)
This will put this date at the start of the Next Week after “Modified”
ModifiedReportEnd
Make it a calculated field, and give it the formula:
=Modified+14-WEEKDAY(Modified)
This will put this date at the end of the Next Week after “Modified”
Create a View with a Filter
Filter where:
ModifiedReportStart is less than [Today]
AND
ModifiedReportend is greater than or equal to [Today]
Tada.
If you looking into trying to make these date filters dynamic, good luck, I haven’t figured or found that one out yet. BUT, here’s where you find the reference for filters and formulas in sharepoint lists on your sharepoint server:
C:\Program Files\Microsoft Office\Office12\1033\STSLIST.CHM