GUI_DOWNLOAD Date format

[balaji_viswanath]

Hi,

I am downloading an internal table to excel through GUI_DOWNLOAD function module, internal table contains a date field and it's getting downloaded in "YYYYMMDD" format. Whereas if we use WS_DOWNLOAD it's getting downloaded with date separator (based on user settings) i.e. slash, dot and etc. Is GUI_DOWNLOAD has this shortcoming?

Regards,

Balaji Viswanath.

[balaji_viswanath]

Hi,

I am downloading an internal table to excel through GUI_DOWNLOAD function module, internal table contains a date field and it's getting downloaded in "YYYYMMDD" format. Whereas if we use WS_DOWNLOAD it's getting downloaded with date separator (based on user settings) i.e. slash, dot and etc. Is GUI_DOWNLOAD has this shortcoming?

Regards,

Balaji Viswanath.

[Former Member]

Try populating the paramter DAT_MODE with 'X'.It should work.

[former_member774460]

Thank you, its working.

[former_member632458]

IF u want the same formate as in the database upload the file in 'DBF' format.

[former_member611314]

if you want the format same as the format of internal table populate the FM like below

CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
filename = gv_path1
filetype = 'ASC'
append = abap_true
write_field_separator = abap_true
dat_mode = abap_true