OLE Export Issue
Hi there,
I'm exporting a report to Excel using OLE. (Using the C++ components)
I have formatted the date columns as both 'c' and 'dd/mm/yyyy'.
When the day and month columns are both less than 12 (ie 3/11/09 (3rd of Nov.)) it flips the date to be 11/3/09, however when the date is say 27/10/09 it leaves as is.
Is this a FR problem or Excel. I'm not sure who I should be addressing? Obviously if it is FR problem, is there a cure?
All the best
Mark
I'm exporting a report to Excel using OLE. (Using the C++ components)
I have formatted the date columns as both 'c' and 'dd/mm/yyyy'.
When the day and month columns are both less than 12 (ie 3/11/09 (3rd of Nov.)) it flips the date to be 11/3/09, however when the date is say 27/10/09 it leaves as is.
Is this a FR problem or Excel. I'm not sure who I should be addressing? Obviously if it is FR problem, is there a cure?
All the best
Mark
Comments