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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
IF
Post Prodigy
Post Prodigy

text format date in power query - m

i tried the code: = Date.ToText(Date.From(DateTime.LocalNow()), "dd.MM.yyyy") to get the date in text format, but i got wrong result as attached. it shows "00" instead of "12".  is there any other way to solve it or get the date with dd, mm, yyyy format? thanks in advancePBI12.JPG

4 ACCEPTED SOLUTIONS
tackytechtom
Super User
Super User

Hi @IF ,

 

Try it with "M" instead of "m":
"dd,MM,yyyy"

 

tackytechtom_0-1702655168628.png

 

Let me know if this works 🙂 Do not forget to mark this answer as a solution in case it was the solution. That makes it easier for other people, too.

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

slorin
Super User
Super User

Hi

MM = month

mm = minutes

 

 

View solution in original post

Syndicate_Admin
Administrator
Administrator

Hi @Syndicate_Admin 

Please try below code

 

= Date.ToText(Date.From(DateTime.LocalNow()), [Format="dd MM yyyy"])

 

 


If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 👍

 

Thanks
Pijush

View solution in original post

6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

Hi @Syndicate_Admin 

Please try below code

 

= Date.ToText(Date.From(DateTime.LocalNow()), [Format="dd MM yyyy"])

 

 


If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 👍

 

Thanks
Pijush

slorin
Super User
Super User

Hi

MM = month

mm = minutes

 

 

tackytechtom
Super User
Super User

Hi @IF ,

 

Try it with "M" instead of "m":
"dd,MM,yyyy"

 

tackytechtom_0-1702655168628.png

 

Let me know if this works 🙂 Do not forget to mark this answer as a solution in case it was the solution. That makes it easier for other people, too.

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

No, it is not working to use it as an input to get data from the SAP. 

dttt.jpg

PBI13.JPG

Thanks, but mine is different

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.