Apr 20 2021 10:30 AM
In Power Query I'm adding a custom column and then changing the data type to a Date. The output correctly shows the day and years in Power Query Editor. However, when I Close & Load, the day increases by one and the year is increased by 4.
Does anyone know why this is?
I've verified the Locale is set to Date & US.
Apr 20 2021 10:46 AM
Solution@Joshua_DeFrank I suspect that you have selected to use the 1904 date system. Check this out
https://docs.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system
Apr 23 2021 10:13 AM
@Riny_van_Eekelen -- thanks that was exactly it!
Apr 20 2021 10:46 AM
Solution@Joshua_DeFrank I suspect that you have selected to use the 1904 date system. Check this out
https://docs.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system