SOLVED

Inconsistent Dates

New Contributor

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

RustikRoberts_0-1656582018236.png

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

RustikRoberts_1-1656582048963.png

 

3 Replies
best response confirmed by RustikRoberts (New Contributor)
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.

 

Riny_van_Eekelen_1-1656582677310.png

 

Magic - Thank you @Riny_van_Eekelen

@RustikRoberts Glad I could help!