date format while downloading data into open office excel

[Former Member]

Hi experts,

i am trying to download hr personal data into excel from an internal table using GUI_DOWNLOAD, where date field, in excel, are having 2 different types of date format and the formats are :

1) 05/08/52

2) 22.04.1957

But i want to maintain only one type date format... preferably the 2nd one.

please help me out in this....

with regards.

Praveen

[Former Member]

Hi experts,

i am trying to download hr personal data into excel from an internal table using GUI_DOWNLOAD, where date field, in excel, are having 2 different types of date format and the formats are :

1) 05/08/52

2) 22.04.1957

But i want to maintain only one type date format... preferably the 2nd one.

please help me out in this....

with regards.

Praveen

[Former Member]

Hi,

Convert the date fields in the internal table using conversion routines.

Regards

Praveen