Forum Discussion
Solved
Power Query Format Date - Wrong millenium
Hello, When I import my csv, there is a column with dates. The csv file shows the dates as DD/MM/YY. When put in YYYY inside Power Query, it assumes every year is from the 19YY except the 40'...
Check your computer's Regional Settings, particularly the 2-digit year cutoff.
Appreciated Todd, it is solved 🙂 It was hard to find the solution to this problem with the keywords I have used
