Thursday, August 02, 2012 9:29 PM
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!
Friday, August 03, 2012 12:39 PMModerator
Friday, August 03, 2012 3:18 PM
add 2 conditions in format/filter the rows
First one is that you mentioned
[date_calibration] < [Today]+30
[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
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.
- Marked As Answer by Entan MingMicrosoft Contingent Staff, Moderator Thursday, August 09, 2012 6:20 AM