6 Replies Latest reply: Nov 10, 2011 6:18 PM by sarath chennupati RSS

getting Char to Date field when i write to Excel

sarath chennupati
Currently Being Moderated

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

Actions