Conditional Format Row, due this month

Question

I have a custom list with a "Date of Next Calibration" column. This column is a date picker control in my form (not time). I want to format the rows of all items that are due for calibration this month. I have found various articles that attempt to fromat rows based on a calculation of [Today]+30, but this is an issue in my instance because this will not only return items due this month, but will include items due next month that fall within today's date +30 days.

I am not fluent in coding at all so I am not even sure if this is possible. Any help/suggestions are greatly appriciated!

---

MG

Answer 1

Hi,

Thank you for your post.
I'm trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thanks ,
Entan Ming

---

Entan Ming

TechNet Community Support

Answer 2

Hi

add 2 conditions in format/filter the rows

First one is that you mentioned

[date_calibration]   < [Today]+30

 and add

AND

[substring(ddwrt:FormatDate(@Created,1033,1),1,2) = substring(ddwrt:FormatDate(@Modified,1033,1),1,2)]

FormatDate(@Created,1033,1), will format the date like 08/03/2012 - today 03. August 2012

and substring(___,1,2) will extract first 2 chars from the string starting form 1 char

More infos about formating, in this post

http://shbdev.wordpress.com/2010/06/28/how-to-format-date-value-in-sharepoint-data-view-web-part-xslt/

---

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.