Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have been able to successfully format a list based on due date. Eg. Due date - 7 is green and due date >= current date in red. etc.

I have done this using SPD2010. The challenge here is that the formatting is lost when the month changes over. Eg: Current date: 25th of July and Due date: 1st of Aug, we do not see the rows formatted. Here's what I have:

ddwrt:DateTimeTick(ddwrt:GenDisplayName(string($thisNode/@Due_x0020_date))) >=  ddwrt:DateTimeTick(ddwrt:GenDisplayName(string(@Current_x0020_Date))) and $thisNode/@Status != 'Completed' and (number(ddwrt:FormatDateTime(ddwrt:FormatDate(string($thisNode/@Due_x0020_date),1033,1),1033,'yyyyMMdd')-7) < number(ddwrt:FormatDateTime(ddwrt:FormatDate(string(@Current_x0020_Date),1033,1),1033,'yyyyMMdd')))

Any solution out will be hugely appreciated.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.