Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

getting Char to Date field when i write to Excel


I am facing funny problem.

I have a varialble, please see below


I_LGTYP = '01-01-01'.

when i write this value into XLS file using GUI_DOWNLOAD FM, It is converting as Date and writing in Excel as 1/1/2001

i tried different options by declaring I_LGTYP as NUM10 and then it is writing as 10101

String same as CHAR.

please tell me how can i reslove this problem as i would like to see in Excel as 01-01-01.

I tried typing 01-01-01 in excel it immediatley changed to date format 1/1/2001, then i tried '01-01-01 and this time it works.



Helpful Answer

Not what you were looking for? View more on this topic or Ask a question