3.2.0

Grid Date format bug

Hi Alex,

I have an XML source with some dates in "yyyy-mm-dd" format. I'm populating the grid and telling it to format these dates using "mmm d yyyy"

The format day is off by -1.

e.g.
The data says
"<lastUpdate>2009-03-12</lastUpdate>"

The grid shows "Mar 11 2009"

To see samples of the data and grid being used go to
http://69.63.135.111/test/
http://69.63.135.111/test/data.xml
Rodrigo
May 14,
I forgot to mention. I'm using the developer version 2.5.3 I downloaded today.
Rodrigo
May 14,
http://www.activewidgets.com/aw.formats.date/setdatatimezone.html

You may need to specify the timezone (it could be that the source is assumed to be GMT and the output is your local timezone).
Alex (ActiveWidgets)
May 14,
I tried that and it didn't work.
I tried both
setDataTimezone(-4*3600000); // EDT
and
setTextTimezone(-4*3600000); // EDT

I did try one thing without setting a timezone, I replaced
"<lastUpdate>2009-03-12</lastUpdate>"
with
"<lastUpdate>2009-03-12 4:00:00 AM</lastUpdate>"

and it did the trick.

I also tried the following:
"setTextTimezone(0);" gave me the correct date
"setTextTimezone(1);" gave me the correct date
"setDataTimezone(-1);" gave me the wrong date
"setTextTimezone(-0.0001220703);" gave me the correct date
"setTextTimezone(-0.0001220704);" gave me the wrong date

It's definitely not working as intended.
Rodrigo
May 14,

This topic is archived.

See also:


Back to support forum