Archived discussions are read-only. Learn more about Q&A or ask a question.

getting Char to Date field when i write to Excel

HI,

I am facing funny problem.

I have a varialble, please see below

I_LGTYP TYPE CHAR10

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.

Thanks

Sarath

Helpful Answer

by