Tuesday, July 27, 2010

sharepoint 2007 - group list by week

Was googling for sharepoint formulas on retrieving a week number based on date when this came up 2nd on top.
http://sharepoint-guru.blogspot.com/2008/03/group-list-by-week-number.html

Nifty, short and sweet.
INT(([Column name]-DATE(YEAR([Start Time]),1,1))/7)

Monday, July 26, 2010

Related Posts Plugin for WordPress, Blogger...