SP 2013
Use case- To pull all the relevant items for a weekly (every Wednesday) meeting from one place, in this case hopefully a list view to go to view this.
Hi guys, I’m hoping to tackle something that I keep hearing about but I sure as heck can’t get this to work. We have a list with a field called “submitted date” we need to be able to see a list view of items with submitted date from last Wednesday to next Wednesday..so today(11/19) we should see items with submitted date anywhere from 11/12 to 11/19..and tomorrow(11/20), we should see items from (11/19 to 11/26). I spoke to a couple of your in the chat forum which helped me a little bit but unfortunately didn’t have time to follow up and thought this might be better medium to ask that.
In any case, this is specifically where I’m stuck- Any reference to [Today] in calculated columns is going to be inaccurate unless there are item updates. So using something like [Today]- Weekday[Today]+3 for last Wednesday (or another one for next Wednesday) as helpful as it is will not be dynamic. So…. what gives? Should I try JavaScript instead? Little bit lost. Is there a SPD hack for this may be?
Appreciate any input.
Thank You!
Samir
update #3:
Turns out part of the problem was in the calculated column. after that it seems to work as expected.
It should be-
Calculated column: StartWednesday =IF(WEEKDAY[Submitted Date])<4, [Submitted Date]-WEEKDAY[Submitted Date])-3, [Submitted Date]-WEEKDAY[Submitted Date])+4)
Calculated column: EndWednesday =IF(WEEKDAY[Submitted Date])<4, [Submitted Date]-WEEKDAY[Submitted Date])+4, [Submitted Date]-WEEKDAY[Submitted Date])+11)
