Forum Discussion
IF
2 years agoPost 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 wa...
- 2 years ago
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/ - 2 years ago
- 2 years ago
Hi
MM = month
mm = minutes
- 2 years ago
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
2 years agoSuper User
Hi
MM = month
mm = minutes