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.
1] Go to the Export Dataset Wizard
2] Set the Date format to Dd/Mm/Yyyy Hh:mm:ss (rather than Mm/Dd/Yyyy Hh:mm:ss) and re test the issue.
1] Open the Excel file you are storing the data to.
2] Right click on the date field and choose Format
3] In the Number tab go to Custom and choose the format dd/mm/yyyy hh:mm:ss
4] Close the Excel file, save changes and re test the issue