7/20/2008 3:05:45 PM

Javier, thanks for stopping by. Make sure you

a) create a Today (any data type) column, before creating your calculated column.
b) delete the Today after your calculated column is saved!

Oscar

8/12/2008 11:57:50 AM

Javier, make sure you delete the 'Today' dummy column in order to see the correct calculated date.

Oscar

9/5/2008 2:23:50 AM

Hi Lauri,

Thanks for stopping by. In XSL you can build an image src using this technique:

<img alt="{@Title}" border="0">
<xsl:attribute name="src">
<!-- if there are amber tasks and no red tasks -->
<xsl:if test="$TotalTasks != $CompletedCount">
<xsl:choose>
<!-- Amber -->
<xsl:when test="$AmberCount &gt; 0 and $NotStartedAndPastDueCount=0 and $RedCount=0">/_layouts/images/ewr214l.gif</xsl:when>
<!-- Red -->
<xsl:when test="$NotStartedAndPastDueCount &gt; 0">/_layouts/images/ewr213l.gif</xsl:when>
<!-- red-->
<xsl:when test="$NotStartedAndPastDueCount &gt; 0 or $RedCount &gt; 0 or $AmberCount &gt; 0">/_layouts/images/ewr213l.gif</xsl:when>
</xsl:choose>
</xsl:if>

<!-- if all tasks are completed -->
<xsl:if test="$TotalTasks = $CompletedCount">
/_layouts/images/ewr212l.gif
</xsl:if>
<!-- if no tasks have been worked on -->
<xsl:if test="$AmberCount = 0 and $RedCount=0 and $CompletedCount=0">
/_layouts/images/ewr226l.gif
</xsl:if>

<xsl:if test="$CompletedCount &gt; 0 and $AmberCount=0 and $RedCount=0">
/_layouts/images/ewr212l.gif
</xsl:if>

</xsl:attribute>
</img>

Oscar