Lavanya 0 Report post Posted December 11, 2008 Hi, I am using GridFX and it gets populated from a datasource. I have a datacolumn type Datetime. It shows all the date values correctly except for 11/1/2001. The data is coming in as 11/1/2001. but when it gets displayed on the grid it is showing 10/31/2001. Any guess on why it is happening? -Lavanya. Quote Share this post Link to post Share on other sites
Frank 0 Report post Posted December 12, 2008 It is a DateTime field? My guess would be that in the DB it is not 11/1/2001 but 10/31/2001 at a time close to midnight of the next day but not quite. When you see the value in your DB as a DateTime, what do you see as the time part? Quote Share this post Link to post Share on other sites
Lavanya 0 Report post Posted March 24, 2009 I checked the data in the database. It is 11/1/2001 12:00:00 AM. When I changed this date to 11/1/2001 1:00:00 AM, it appears properly on the grid as 11/1/2001. But why is this happening for this date alone. There are other dates in the grid with the same timestamp and all those dates look good. Is this a bug in GridFX? Thanks, Lavanya. Quote Share this post Link to post Share on other sites