Task: I had a list with two date fields and I wanted to have the most recent dates first in the list. Solution: Create a calculated field (format=date): =IF([Date INT] Then I had a third field which I could use to sort.
SP calculated fields: http://abstractspaces.wordpress.com/2009/05/02/common-date-time-formulas-for-sharepoint-calculated-fields/ cw =INT((Created-DATE(YEAR(Created),1,1))/7) This is for calendarweeks as in Outlook: cw 1 is the first week in the year with a Monday. =INT(([Date Production]-DATE(YEAR([Date Production]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Production]),1,1)),"d")-1))/7)