topic Re: Change (Default) Date format while saving from ALV to Excel in Application Development and Automation Discussions

Change (Default) Date format while saving from ALV to Excel

Former Member — Mon, 07 Jul 2014 07:18:29 GMT

Hi,

When I download Excel file from ALV the Date fields get converted to the local settings in my computer (the settings from MS Office config). But I want to keep the date format that of in SAP. i.e. I want to save excel file with date fields formatted as the date format I see in ALV output.

Is there any way out to do this?

Regards,

Sourav

Re: Change (Default) Date format while saving from ALV to Excel

Former Member — Mon, 07 Jul 2014 07:25:18 GMT

Hi Sourav,

My advice:

1.change the field type of date to char type and properly extend the length

2.add ' before the value of date.

Thanks,

Sam

Re: Change (Default) Date format while saving from ALV to Excel

naveenvishal — Mon, 07 Jul 2014 07:27:23 GMT

Hi Sourav,

Instead of passing back as a date, pass it back as a character. It will then retain the same format in excel download.

Hope this helps.

Regards,

Naveen

Re: Change (Default) Date format while saving from ALV to Excel

Former Member — Mon, 07 Jul 2014 07:29:19 GMT

Thanks Sam.
Actually that solution occurred to me. I am looking for a bit more legitimate way if there is any.
Suppose I need sorting the date field.

Anyway thanks..

Re: Change (Default) Date format while saving from ALV to Excel

naveenvishal — Mon, 07 Jul 2014 07:37:50 GMT

Try concatenating ' (single quote) in front of the date and passing it for the excel download.

Hope this helps.

Rgds,

Naveen