为“上周"创建计算列 [英] Create Calculated column for "Last week"

问题描述

你好；

我一直在网上寻找解决方案，但我所做的没有给我想要的结果.我希望有人能提供帮助.

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

这篇关于为“上周"创建计算列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！