[SharePoint 2010] 項目清表按月份分組顯示

  • 3782
  • 0

[SharePoint 2010] 項目清表按月份分組顯示

如果你有一個SharePoint 項目清單包含一個日期的欄,你可能想要建立一個按月分組的檢視。例如:在一個工作清單表中,你能建立一個按月分組的檢視。

首先,建立一個計算欄,讓它返回一個字串值並在計算公式(Formula )輸入框中輸入如下公式:

=YEAR([Modified])&"-"&CHOOSE(MONTH(DATEVALUE("1/"&MONTH([Modified])&"/"&YEAR([Modified]))),"01. January","02. February","03. March","04. April","05. May","06. June","07. July","08. August","09. September","10. October","11. November","12. December"),其中Modified為已存在的日期類型的列。

image

image

image