I have a list that has a datestamp column. This gets updated by a workflow.
I want to be able to display all items from nthe list where datestamp is between Sunday gone and today
So if today is friday I want to see all items from sunday to today. Tomorrow this list will change as tomorrow is saturday and it will display more items. The display resets on sunday as its the beginning.
Can this be done via CQWP ? Can this be done via CQWP ?
UPDATE:
I think I need a query like this in the 'Custom Value or Query' field of a CQWP
If today = monday return -1 If today = tuesday return -2 etc
Thanks