Forum Discussion
Solved
Changes in format of Date columns in Pivot Table
This UK date format 11-05-2024 (General) in source data (Get from folder) is auto recognized as 11-05-2024 (Date) in Transformation/Combined), but when Closed/Loaded the date is converted to USA format, 05/11/2024.
Also, source data date 21-05-2024 reports as error when changing from General to Date in Transformation.
I meant Power Query regional settings, please check them. Data->Get Data->Query Options->Regional settings->locale
done for the Excel workbook in which you run query.
5 Replies
I guess you transform with Power Query. What are your regional settings for it
they are here
and what are your regional settings for Windows (if you are on that platform)?
Hi, I confirmed that Windows and Excel are ser to UK English, but I can't check when I'm in the pi ot table.
Please check to be sure.
As workaround you may change type using locale from right click menu on column in Power Query
