After migrating to SP2010 Foundation, I've discovered that for some reason I can't group a list by a calculated date field.
Create a list with a date column A. Create another column B with a simple calculated date of [A]+1 and use the field format type 'date'
Modify view to group the list by column B.
You're list will load, but when you attempt to expand one of the groups you'll be greated with an exception error. Why?? Am I doing something wrong?
Note: You can group fine if the data type for column B is anything except 'date' format, but I really need to group items by a calulated date.
Ultimately, what I'm trying to do is group my list items by week by calculating the end of the week using a simple formula =[Must ship by]+7-WEEKDAY([Must ship by]) then I want to gropu by the [Must Ship by] column like I always did
in SP 2007, but now it errors out. I also wanted to create my own timesheet template since the Fab 40 templates aren't available for 2010, but I can't really do that effectively without being able to group timesheet entries by week.
View Complete Post