Wrox Programmer Forums
SharePoint Development Programming and development for SharePoint Portal Server and Windows SharePoint Services
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SharePoint Development section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 19th, 2010, 12:08 PM
Registered User
Join Date: Feb 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Conditional formatting

I am looking for some help!

I have been tasked to create a master list of documents and on this master list of documents I need to apply some conditional formatting. The formatting needed is when a document has past its review date show some indicaition that it has past its review date in my case I have creaed a red green and amber image similar to a KPI indicator and when it is nearing its review date show a different indicator otherwise show an indicator that the document is the current version.

This is what I I have so far:

<xsl:when test="number(translate(substring-before(@Review_x0020_Date,'T'),'-','')-30) &gt; number(translate(substring-before($Today,'T'),'-',''))">
<IMG SRC="http://ross-works/Path Demo/Images1/green_orb.jpg" ALT="{@Status}" />
<xsl:when test="number(translate(substring-before(@Review_x0020_Date,'T'),'-','')) &lt;= number(translate(substring-before($Today,'T'),'-',''))">
<IMG SRC="http://ross-works/Path Demo/Images1/red_orb.jpg" ALT="{@Status}" />

The code snipet is part of a dataview that pulls docs from a linked source. In this case two document libraries. And this works fine has the review date passes the image changes to show that the reveiw date has past, but I need to take this further, what I need to achieve is an intermidate scenario where if the review date in within on month of expiration that show a different indicator to the user that the review date is approaching.

I know this is a sizebale thread but I feel I need to offer as much explanition as possible.

Can anyone help?


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting jeremy1048 Access 4 July 3rd, 2008 11:20 AM
Conditional formatting vemaju Excel VBA 2 June 6th, 2007 04:41 AM
Conditional Formatting on Subform echovue Access 4 March 3rd, 2006 03:25 AM
Conditional Formatting Corey Access 1 November 8th, 2005 12:18 AM
Conditional Formatting... In Access??? lguzman Access VBA 2 September 23rd, 2004 03:52 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.