Forum Discussion

Mengerdahl's avatar
Mengerdahl
Frequent Visitor
2 years ago

Date - Wrong year displayed (formatting problem)

Second formatting problem I cant solve today means second thread here today.. As earlier I seem to get stuck on getting the right format for my columns of the dataset. Im using Swedish settings on my...
Need Help
az38's avatar
az38
Community Champion
2 years ago

Hi Mengerdahl 

where exactly did you try to change local?

There are 2 places - Global and Current File local settings

 

With current file local settings ENglish (United States)  04/01/10 00:00:00 was recognized as 2010 year for me

  • Mengerdahl's avatar
    Mengerdahl
    Frequent Visitor
    2 years ago

    Hi!

    Good question 😉 I tried to change this in Power query when loading the file. Not sure if this is the right way then?