I have declared a DataTable with a primary key column with System.DateTime type.
I present it in a WinGrid.This is done at runtime so I don't get an oppertunity to set things up nicely via the Grid Designer.
Now and then it is exported to Excel in the simplest possible way.
The Date is now in a very user unfriendly format counting the days since beginning of time (MS time that is)
I'm using NetAdvantage 2007.2.
If this is bug is it corrected in 2007.3?
Is there a way to better prepare the
You need a hotfix (available for versions 7.2 and 7.3). See also bug report BR27306
Sorry, need more help!
If BR27306 only fixes what it says then I have a new and much worse problem because
I have also tried no format which works fine in the grid (equivalent of short date pattern as stipulated) but Excel 2007 still reports the date as a number (Julian date)
Could it be an I18N problem?
I am running with an English Windows XP, English Office 2007 and a Danish locale i.e. short date pattern is dd-MM-yy
It seems to affect 2008.3 version too.
Please see http://community.infragistics.com/forums/p/1370/261518.aspx#261518