Changing users date formats in SAP or Excel

[Former Member]

Hi,

I've written a simple script in Excel to run a transaction and import into Excel where it does some formatting to give me a report.

This works great on my setup but when I tested on other users I get varied results around the date format.

One issue was how I set the date fields in the transactions which I've got round, but the issue which has now got me stuck is when I export out of SAP into Excel - see attachment. If the user has his date format setup as DD.MM.YYYY then when I import into Excel the column is text and not in date format, meaning I can't grab week or year info.

I'm thinking that once I've imported the data into Excel then I need to copy characters in the text string and re-create the dates but has anyone else seen and overcome this issue?

Thanks,

Mark

[michael_hobbins · Accepted solution]

Hi Mark, I suggest you use the REPLACE function before inserting the date into the Excel cell. You need to replace the dots for slashes. Excel doesn't understand "12.09.2014" as a date, you need to transform into "12./09/2014"

Cheers,

Michael

[Former Member · Accepted solution]

Perfect! Thanks Michael.