I'm lost in a very simple date format issue that I can't understand. Maybe you can help me looking at it from outside
I have a basic expression to return the month number from today's date:
now I expected this to return a number between 1 and 12 (of type string, but still a number), but instead is returning "November 29"
what am I doing wrong?
thanks for help
Solved! Go to Solution.
just to outline, for whomever is having the same issue.
The 'M' notation is reserved for a standard Date Format pre-built by Microsoft, that will return full Month name + Day of month (i.e.: November 29).
therefore, when using a Custom Date Format (like I was trying to achieve) you're not allowed to return month number with a single digit, but you're obliged to use 'MM' notation.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!