XL sheet - Date format

[Former Member]

Hi,

I am downloading data to internal table using FM 'GUI_DOWNLOAD'.

Internal table contains a date field in the format 'YYYY-MM-DD'.

Now when i am downloading the date field is automatically

chnaged to dd/mm/yyyy into XL sheet.

how to get resolve from this issue?

helpful answers will be rewarded.

Thanks,

Anil

[Former Member]

Hi,

I am downloading data to internal table using FM 'GUI_DOWNLOAD'.

Internal table contains a date field in the format 'YYYY-MM-DD'.

Now when i am downloading the date field is automatically

chnaged to dd/mm/yyyy into XL sheet.

how to get resolve from this issue?

helpful answers will be rewarded.

Thanks,

Anil

[former_member195383]

try changing the format of the cell in the excel itself...

[Former Member]

This is the normal problem occurs during download.

In order to resolve it take date field in your final internal table as a character format length 10.

Move the specified format of date in this character string and then perform the download functionality.

Reward if useful.

[Former Member]

Hi,

Try changing the date field to character.

Cheers,

Sai

[Former Member]

Hi Anil,

Iam also facing the same probelm, can u please let me know the solution for this. if u have the solution please let me know.

i think this should be changed in excel sheet properties it self.

excel sheet date format cannot be handled in the program.

[Former Member]

Hi

In Excel Sheet change the Cell Properties with respect to the date format you want.

Or

try to stored data in .CSV format ( Same as Excel).

Hope it will helpful to you.

Thanks & Regards

Nikunj Shah

[Former Member]

this function module

MS_EXCEL_OLE_STANDARD_DAT is used to down load the data in to excel sheet, this function module is using the function module 'gui_download' function module.

in this function module 'field type is commented' fiel type .CSV cannot be selected here.

Please let me know if there is any other method for this.

Tirumal.

[former_member386202]

Hi,

Declare field in internal table type character with length 10 write date to that field in format which u want .

Regards,

Prashant