cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sacheu
New Member

How can i get the month in string on a date 20 days ago from now

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:

 

addDays( formatDateTime(utcNow(), 'dd-mm-yyyy'), -20)
 
But I get an error saying 
 
In function 'addDays', the value provided for date time string '15-28-2020' was not valid. The datetime string must match ISO 8601 format.'.
 
Can you please tell me if there is another way to do this?
2 REPLIES 2
RobElliott
Super User
Super User

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:
MM.png

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.

 

v-alzhan-msft
Community Support
Community Support

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.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (821)