Log In
Register
Home
New Member
June 15, 2024
Offline
Hi,
In my source spreadsheet there is a column that contains the date and time of the transaction in the same field as „2024.05.15 19:35:54”
When imported into the Power Query, if I change the data type "ABC123" to "Date", I get an error.
However, if I change the data type "ABC123" to "Date/Time" first, there is no error and the result is “2024. 05. 15. 19:35:54.” If I change the data type again now to "Date" in another step, it works in this case and the result is “2024. 05. 15.”
I have no idea why it doesn't work in one step, and why it works in two steps. (The only thing I noticed is that after I changed it to "Date/Time" in the first step, Power Query put an extra "." after the date and the second).
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Peter,
Before converting to Date, try replacing the "." with "-" or use the Locale date conversion, the "." date separator is not used in US, only few countries are using this separator. The date seems to be in a modified international format yyyy-mm-dd but with dots instead, otherwise use the "/" separator.
1 Guest(s)
