We encountered a weird issue.. we don't know where to look anymore. Let me
explain:

We tried to add simple Conditional Formatting on a Date Column within a
list. This list is converted to a xslt data view.
After this we applied formatting. Which should make the background RED when
the Date inserted in the column Equals CurrentDate.
But what happends is.....nothing! The weird thing is when we enter the date
of tommorow the field gets red! somehow the value $today contains the date
of tommorow.
We want it to contain the date of today. It must be something with the way
the date is substracted from the iso time.
We know it's an issue only in this enviroment because everything works well
when we try to replicate the situation on a VPC.
What we tried so far:
- <xsl:attribute name="style">
<xsl:if test="number(translate(substring-before(@Startdatum,'T'),'-','')) =
number(translate(substring-before($Today,'T'),'-',''))">background-color:
#FF0000;</xsl:if>
</xsl:attribute>
- we tried to throw an format over $today looking like this.
ddwrt:FormatDate(string($Today) ,1043 ,1)
- we checked the regional settings on the MS 2003 Server, On CA lvl,
Site-Collection lvl, and Site LVL. it's all on the dutch time zone.
- When you create an item it displays the correct date on date created. It
looks like the $today is filled from a different location.
- It must be something in this production and test enviroment because i
cannot replicate this issue on a test VPC.
Are there more places where we can check the date settings? Or anyone that
encountered the same issue before?

We really don't know where to look anymore hopefully anyone can help!