Hi,
I am trying to get the month in string on a date 20 days ago from now
Here is the expression I tried in my flow:
Hi @sacheu ,
You could take a try with expression below to achieve the requirement:
formatDateTime(addDays(utcNow(),-20),'MM')
Please let me know if your problem could be solved.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sacheu in Power Automate months are always in upper case MM. Lower case is for minutes. One way to get just the month is to use a Convert time zone action:
The output of MM will be 12, MMM will give you Dec and MMMM December and you can use the Converted Time output in follow-on actions.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
WarrenBelz
146,635
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional