Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Weird Date Problem using Conditonal Formatting

  Asked By: Carlton    Date: Aug 08    Category: Sharepoint    Views: 1298

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!

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Latisha Schneider     Answered On: Aug 08

I presume that you already checked the date/time and time zone of the
server's in the farm.

 
Answer #2    Answered By: Nora Maxwell     Answered On: Aug 08

Yes this is checked they show the correct date  and settings are the same.

 
Answer #3    Answered By: Corina Duran     Answered On: Aug 08

I found the Solution to this one. I had to use IsoToday() instead of $Today
then it worked.

 
Didn't find what you were looking for? Find more on Weird Date Problem using Conditonal Formatting Or get search suggestion and latest updates.




Tagged: