Date format is incorrect when using Export Dataset to Excel.
To reproduce the problem please follow the steps below:
1] Lets assume that there is a select statementthat returns the date:10/01/2010.
2] Right click on the datagrid and choose Export Dataset
3] Choose Export to Excel and ClickOK
4] Open Excel: The date format has been incorrectly stored as 01/10/2010, rather than 10/01/2010.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center