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)
ddMMyy
is presented as 39471.
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