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
Within a calculated column that might be difficult, but not with a view.
You would create a view that filters based on the following:
Filter where:
[Submitted Date]
is greater than or equal toÂ
[Today]-7
andÂ
[Submitted Date]
is less than or equal toÂ
[Today]+3
that should do it, I do that very frequently.
