text format date in power query - m

[IF]

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 advance

[tackytechtom · Accepted solution]

Hi @IF ,

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

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/

[AlienSx · Accepted solution]

[slorin · Accepted solution]

Hi

MM = month

mm = minutes

[Syndicate_Admin · Accepted solution]

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 · Accepted solution]

Hi

MM = month

mm = minutes

[tackytechtom · Accepted solution]

Hi @IF ,

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

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/

[IF]

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

[AlienSx · Accepted solution]

[IF]

Thanks, but mine is different