getting Char to Date field when i write to Excel
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.