Forum Discussion
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 advance
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/Hi
MM = month
mm = minutes
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
6 Replies
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/Hi
MM = month
mm = minutes
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
