问题描述
你好;
我一直在网上寻找解决方案,但我所做的没有给我想要的结果.我希望有人能提供帮助.
I have looked online for solutions to this, but nothing I am doing is giving me the results I'm looking for. I hope someone can help.
我正在尝试创建一个SharePoint视图,以显示在上周(其中上周"是星期六至星期五)期间修改过的列表中的每个项目.
I am trying to create a SharePoint view that shows every item in a list that was modified during the prior week (where "prior week" is Saturday through Friday).
例如,如果我查看18日星期三的列表,我想查看所有包含修改"日期中的日期的项目.列是介于7日(星期六)和13日(星期五)之间的日期.
For example, if I look at the list on Wednesday the 18th, I want to see all items where the date in the "modified" column is a date between and including Saturday the 7th and Friday the 13th.
有人可以帮忙吗?非常感谢.
Can anyone help with this? Thanks so much.
推荐答案
您可以使用3个计算出的列和过滤器视图来实现此目的.
You can achieve this using 3 calculated columns and filter view.
已修改的计算列(CalcModifiedWeek)
= INT((modified-DATE(YEAR(modified-WEEKDAY(modified-1)+4),1,3)+ WEEKDAY(DATE(YEAR(modified-WEEKDAY(modified-1)+4),1, 3))+ 5)/7)
=INT((modified-DATE(YEAR(modified-WEEKDAY(modified-1)+4),1,3)+WEEKDAY(DATE(YEAR(modified-WEEKDAY(modified-1)+4),1,3))+5)/7)
计算列周数(CalcCurrentweek)
= INT((Now()-DATE(YEAR(Now()-WEEKDAY(Now()-1)+4),1,3)+ WEEKDAY(DATE(YEAR(Now()-WEEKDAY(Now( )-1)+4),1,3))+ 5)/7)
=INT((Now()-DATE(YEAR(Now()-WEEKDAY(Now()-1)+4),1,3)+WEEKDAY(DATE(YEAR(Now()-WEEKDAY(Now()-1)+4),1,3))+5)/7)
计算列差异(CalcWeekdiff)
CalcCurrentweek- CalcModifiedWeek
在那之后创建一个视图
过滤器:Calcweekdiff 等于1.
Filter : Calcweekdiff is equal to 1 .
如果帖子解决了您的问题,请记住单击标记为答案" 投票为有帮助的人" (如果有用)
Please remember to click "Mark As Answer" if a post solves your problem or"Vote As Helpful" if it was useful
这篇关于为“上周"创建计算列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!