Convert text Column to date Format="yyyy-MM-dd HH:mm:ss.fff", Culture ="en-US" in Power query

[sidyahmed_pbix]

I have the column in text and i want to convert it to date with the specific format in power query "yyyy-MM-dd HH:mm:ss.fff", Culture ="en-US" .
Can someone help me please.

[Idrissshatila]

Hello @sidyahmed_pbix ,

click on the ABC icon as in your screenshot and pick date/time type.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[sidyahmed_pbix]

Hello @Idrissshatila 
when i do that i get the error

and the error is :  DataFormat.Error : Désolé... Nous n'avons pas pu analyser l'entrée fournie à une valeur DateTime.
Détails :
2023-05-09 15:26:00.838

[Idrissshatila]

Hello @sidyahmed_pbix ,

so what you need to do first is to remove the numbers after the dot in the end then convert it.

to remove the numbers after the dot you need to use extract after delemiter so you could take it off,

check this video to see how https://youtu.be/OyvXRIIWTPg?si=AsmnLNizOyCEIIQF

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡