Power Query Format Date - Wrong millenium

[JorgeDias]

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,

[ToddChitt]

Check your computer's Regional Settings, particularly the 2-digit year cutoff. 

[ToddChitt · Accepted solution]

Change the date system, format, or two-digit year interpretation - Excel (microsoft.com)

[JorgeDias]

Appreciated Todd, it is solved 🙂 It was hard to find the solution to this problem with the keywords I have used