SharePoint文档库列表本周本月创建记录动态视图的设置

我们在SharePoint文档库或者列表工作时,经常需要统计一些数据,诸如本周创建的条目,本月创建的记录,等等,那么,如何创新一个新视图并且让视图自动动态显示这些数据?
(1) 首先我们需要设定一周或者一个月的起止日期,这个可以通过创建2个字段来实现,字段属性为:calculated,比如:
WeekStart字段,值为: =[Created]-(WEEKDAY([Created],2)-1)
WeekEnd字段,值为: =[Created]+(5-WEEKDAY([Created],2))
MonthStart字段,值为: =DATEVALUE("1/"&MONTH([Created])&"/"&YEAR([Created]))
MonthEnd字段为,值为: =DATEVALUE(CHOOSE(MONTH([Created]),31,28,31,30,31,30,31,31,30,31,30,31)&"/"&MONTH([Created])&"/"&YEAR([Created]))
(2) 创建新的视图,并设置相应的过滤条件
本周创建的条目:
WeekStart is less than or equal to [today]
WeekEnd is greater than or equal to [today]
本月创建的记录:
MonthStart is less than or equal to [today]
MonthEnd is greater than or equal to [today]
设置完成,我们就可以使用本周或者本月动态视图了。

原文地址:https://www.cnblogs.com/shp168/p/3666742.html