Groups | Blog | Home
all groups > coldfusion flash integration > february 2006 >

coldfusion flash integration : CFGrid displays the wrong date - sometimes


SHAREMaster
2/2/2006 11:00:47 PM
I have found that when using CFGrid in Flash the dates in Feb/Mar and Nov/Dec
in 1942 will display one day earlier than in the database if using a Windows
computer. This consistently happens on multiple computers/browsers. The dates
display fine on a Mac. Again, the date displayed in the grid is one day
earlier than the date in the database (MSSQL)

It doesn't seem to matter whether data binding is being used or not. It
doesn't happen on most dates. Problems with Nov/Dec dates in the 1940's seem
to be the most prevalent. Has anyone else noticed this? Is there a solution?

I've submitted a bug-report twice now with no response so I can't tell if it
arrived.
PaulH *TMM*
2/4/2006 12:43:25 AM
[quoted text, click to view]

SHAREMaster
2/5/2006 12:00:00 AM
I'm in the Pacific Standard Timezone (PST).

The problem is fairly unusual though (I think). It occurs on Windows clients,
not Macs. It happens to a few dates in certain date ranges but consistently
occurs on those dates (i.e they appear one day earlier in the grid than they
actually are).
PaulH *TMM*
2/5/2006 12:00:00 AM
[quoted text, click to view]

and that's the tz that gives you problems?

the olsen data (the tz database used by pretty much everyone) is full of
historical data (if if you give it a date in the past, that historical date's
exact tz behavior is what you're supposed to get back). you might be falling
into one of the WWII tz changes. if that's correct, the MAC is actually misbehaving.

i'll poke thru the olsen data for PST tz changes during that time.
PaulH *TMM*
2/7/2006 1:19:08 AM
[quoted text, click to view]

AddThis Social Bookmark Button