on 02-03-2015 8:20 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.