Forum Discussion

RustikRoberts's avatar
RustikRoberts
Copper Contributor
Jun 30, 2022
Solved

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...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 30, 2022

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