topic Re: XL sheet - Date format in Application Development and Automation Discussions

XL sheet - Date format

Former Member — Thu, 26 Jun 2008 05:39:25 GMT

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

Re: XL sheet - Date format

former_member195383 — Thu, 26 Jun 2008 05:41:56 GMT

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

Re: XL sheet - Date format

Former Member — Thu, 26 Jun 2008 05:43:47 GMT

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.

Re: XL sheet - Date format

Former Member — Thu, 26 Jun 2008 05:48:13 GMT

Hi,

Try changing the date field to character.

Cheers,

Sai

Re: XL sheet - Date format

Former Member — Tue, 08 Jul 2008 07:13:24 GMT

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.

Re: XL sheet - Date format

Former Member — Tue, 08 Jul 2008 07:16:01 GMT

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

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

Hope it will helpful to you.

Thanks & Regards

Nikunj Shah

Re: XL sheet - Date format

former_member386202 — Tue, 08 Jul 2008 07:17:10 GMT

Hi,

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

Regards,

Prashant

Re: XL sheet - Date format

Former Member — Tue, 08 Jul 2008 07:28:41 GMT

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.