Forum Discussion
Reformatting and change the order of date
LarissaM711 as this is a Locale issue, you need to process the date/time as a US type date (that's what it looks like).
Try adding this step in after the initial loading of the data into Power Query:
= Table.TransformColumnTypes(#"Changed Type", {{"Veröffentlichungszeit", type datetime}}, "en-US")
This can be done through the editor by clicking the following:
(using Locale)
Date/Time & English (US)
Hope that helps!
Hey,
i got the csv now and tried to convert the text Date-field with PowerQuery in a Date-field. But here it is the exact same strange thing, that some Rows cannot tbe transformed into a date-field. (Error: The specification for a DateTime value could not be analysed)
I don't know what to do... I attach the CSV here..
LarissaM711 as this is a Locale issue, you need to process the date/time as a US type date (that's what it looks like).
Try adding this step in after the initial loading of the data into Power Query:
= Table.TransformColumnTypes(#"Changed Type", {{"Veröffentlichungszeit", type datetime}}, "en-US")
This can be done through the editor by clicking the following:
(using Locale)
Date/Time & English (US)
Hope that helps!
- omg yeay! Worked!
Thank you so much 🙂