Skip to Content
avatar image
Former Member

Changing users date formats in SAP or Excel

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

error2.JPG (280.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Feb 03, 2015 at 09:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded