Power Query Incorrect Year on Select Values

[jws]

Hello,

I have tried changing the columns to date, text and fiddled around with the options in data load settings, but nothing seems to fix the issue I have.

Issue:

There is a "Date Modified" column that shows the proper mm/dd/yyyy date - what happens is the helper column "Date Created" translates/converts select rows into the wrong year. In the attached example you can see a lot of dates show as Year/2016, 2018, 2019, where it should read Year/2020.

Anyone encounter this or have a solution?

Thanks for looking

 

[jws]

** I solved it by adding a column and entering in the format, I am still scratching my head on why the values are 2016, 2018, 2019 where highlighted

 

[sandy666]

maybe try

 

[jws]

I tried that as well, still showing odd values

 

[sandy666]

I know the date in column is mm/dd/yyyy (in csv)
but I don't know your system date
or
post a link to the shared csv file (if this is not classified )