Inconsistent Dates

[RustikRoberts]

Thanks for any help in advance

I've connected to an SQL data source and imported timesheet data which previews correctly and displays correctly in Power Query Editor

But the Table displays the dates 4 years and a day later and i can't work out why

[#2 · Accepted solution]

@RustikRoberts I suspect that you accidentally set the switch to "Use 1904 date system" under File, Options, Advanced. Make sure to uncheck the box.

[#3]

Magic - Thank you @Riny_van_Eekelen

[#4]

@RustikRoberts Glad I could help!