Forum Discussion

spehe's avatar
spehe
Copper Contributor
Oct 05, 2022
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...
  • Riny_van_Eekelen's avatar
    Oct 06, 2022

    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.

Resources