Forum Discussion
Solved
Excel Date problem
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 Fo...
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.
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.
Spot on! That fixed my problem, thanks a lot!