Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Shawry
Helper I
Helper I

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

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?

 

Shawry_0-1719795125949.png

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Shawry 

 

maybe you can try change type with locale

11.png12.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
ryan_mayu
Super User
Super User

@Shawry 

 

maybe you can try change type with locale

11.png12.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Great, thank you! That worked 🙂

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




VN999
Resolver I
Resolver I

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}})

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.