Forum Discussion
RustikRoberts
Jun 30, 2022Copper Contributor
Inconsistent Dates
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
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 Replies
- Riny_van_EekelenPlatinum Contributor
RustikRoberts I suspect that you accidentally set the switch to "Use 1904 date system" under File, Options, Advanced. Make sure to uncheck the box.
- RustikRobertsCopper ContributorMagic - Thank you Riny_van_Eekelen
- Riny_van_EekelenPlatinum Contributor
RustikRoberts Glad I could help!