Change from mm/dd/yyyy to dd/mm/yyyy and remove time.

[Shawry]

Hi, 

I have a data source that is in mm/dd/yyyy and also includes time. I need to conver this to dd/mm/yyyy and remove the time, but when changing the data type to Date, it errors out. Is there way to resolve this easily?

[ryan_mayu · Accepted solution]

@Shawry 

maybe you can try change type with locale

[Shawry]

Great, thank you! That worked 🙂

[ryan_mayu]

you are welcome

[VN999]

Check with this code:

#"Changed Type" = Table.TransformColumnTypes(Source,{{"DateColumn", type datetime}}),
#"Removed Time" = Table.TransformColumns(#"Changed Type", {{"DateColumn", each Date.From(DateTime.LocalNow()), type date}})