Forum Discussion
text format date in power query - m
- 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
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/
No, it is not working to use it as an input to get data from the SAP.