Skip to Content
0
Former Member
Jan 06, 2012 at 08:02 AM

Issue in displaying DATE field in Excel sheet

83 Views

Hi All,

Kindly help me with the below issue:

A report program when exexuted fetches the data's from database tables and populates in to an itab and the same is then moved to a itab which is declared like this:

DATA: BEGIN OF t_downd OCCURS 0,

line(4096) TYPE c,

END OF t_downd.

This T_DOWND will have all the obtained records and the same is used to pass the entries to GUI_DOWNLOAD function module inorder to save the excel sheet in '.csv' format to the desktop.

The issue is the user wants the 'DATE' field to be displayed in 'DD-MM-YYYY' format in the excel sheet. So I have fetched the date based on the position(fdpos) and used the concatenate statement separated by '-'. Now when I run the program, some dates are not getting displayed in 'DD-MM-YYYY' format and some dates are getting displayed correctly as per the requirement.

While debugging also, I could find the date value in T_DOWND in the 'DD-MM-YYYY' format only. Not sure where it is actually getting changed and why.

Can some one please provide a soultion for this.

Thanks,

Deepa