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
It seems to affect 2008.3 version too.
Please see http://community.infragistics.com/forums/p/1370/261518.aspx#261518
The list of fixes can be found in the Developer Support manager's blog:
BLOGS: Vincent McDonald
To download a hot fix, you can go to your downloads section once you log in:
My Infragistics Keys and Downloads - Download Anything and Everything You Own
I suggest you to first try out the hotfix, and if this doesn't help you can either contact the support or maybe anybody from Infragistics will answer you here