Hi All,
I am having a date of type char10 (dd-mm-yyyy) which i am trying to upload to an excel file(.CSV format) using the FM 'GUI_DOWNLOAD'along with other data. All the dates are in a single column.
The problem is, in the excel sheet for some dates alone, the date is not coming in dd-mm-yyyy format. They are instead getting displayed as mm/dd/yyyy.
If the date is starting with 0 say 01-03-2012, in the excel sheet it is getting displayed as 1/3/2012. However while debugging we found that the value in internal table is in the correct format which is dd-mm-yyyy(03-01-2012). This is also happening for dates starting with 10, 11 and 12.Suppose while debugging the values of dates are 10-22-2009, 11-10-2012 & 12-11-2012 , then the same three dates are getting displayed in excel sheet as 10/22/2009, 11/10/2012 & 12/11/2012 .
For all other cases the dates are getting displayed properly in dd-mm-yyyy format.
We found that when the date is getting displayed properly, the format of the cell in excel sheet is 'GENERAL'.
When the date is displayed wrongly, the cell format in excel sheet shows as 'DATE'. We assume this is why we are not getting the expected date format in the excel.
Please suggest how to proceed to solve this issue.
Thanks,
Deepa