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's, where it assumes is from the 2040's as shown in display.
Any help?
(I passed this file to friends and it converts well for them)
Regards,
3 Replies
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
