OK. So I have done more testing and can confirm it's a SharePoint date issue.
I know that the raw output for Today is coming through as *2013-04-09* T12:26:21Z. When converted ticks this is displaying as 635138496000000000 which is actually *2013-09-04*. If I set the *RegisterBy *date to *04-09-2013* I get the result I expected. It looks like a US date format issue, although both the server and SharePoint site are set to Australia and dd/mm/yyyy date format. Anyone know an easy fix for this? :) On 9 April 2013 12:17, Web Admin <[email protected]> wrote: > Hi all, > > A few weeks back I created a site customisation that used a variety of > Custom List Forms using DVWPs with filtering and conditional formatting. > > I know these all worked because I vigorously tested them all and also > posted here about a few issues I encountered. > > On re-visiting the site today I noticed that the conditional formatting > I'd applied to certain fields was no longer working. These were pretty > simple date comparisons against Today. > > I'm using the following calculation: > > <xsl:when > test="number(ddwrt:DateTimeTick(ddwrt:GenDisplayName( > string(@Register_x0020_By)))) < > number(ddwrt:DateTimeTick(ddwrt:GenDisplayName(string($Today))))" > > > > Outputting the value of these to screen gives the following results. For > some reason *$Today* is calculated wrongly and is significantly larger > than it should be. > > *RegisterBy* 6/05/2013 635033952000000000 > *Today * 9/04/2013 635138496000000000 > > Does anyone have ANY idea why this is occurring? > > Regards, > > Paul >
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
