2. srpna 2012 21:29
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!
3. srpna 2012 12:39Moderátor
3. srpna 2012 15:18
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.
- Označen jako odpověď Entan MingMicrosoft Contingent Staff, Moderator 9. srpna 2012 6:20