Oct 05 2022 06:14 AM
Hello. I get a file every day with telephone statistics from our switchboard. It has the same format every time so in order to be able to merge the data, I want to use the 'Get Data/from File/from Folder'.
Everything works with the merge and I can chose 'Combine and Transform Data'. But when I click on the example file to check the data, the dates are all wrong.
The date format is ok though, but Excel mixes up Year, month and day.
Above is the original file with the dates. Below is the converted dates.
The day have become the year, and the year have become the day....
The file I recieve have been produced in Germany, and I am in Sweden with a slightly different way of writing dates, but I could live with both variants, as long as they are correct. Since I am using the 'Get data/from File/from Folder', I never get a chance to convert the dates before I merge the files, and after, they are wrong. Any help would be deeply appreciated.
Oct 05 2022 08:07 AM
Oct 05 2022 11:15 PM
Oct 06 2022 12:31 AM
Solution@spehe Your Swedish system doesn't recognise 02.05.22 as a date. Change the data type in the #"Changed Type" step for "Call Start Time" and "Call End Time" by "Using Locale..."
and then select Date/Time and choose "German (Germany)" as the locale.
That should fix it.
Oct 06 2022 12:31 AM
Solution@spehe Your Swedish system doesn't recognise 02.05.22 as a date. Change the data type in the #"Changed Type" step for "Call Start Time" and "Call End Time" by "Using Locale..."
and then select Date/Time and choose "German (Germany)" as the locale.
That should fix it.