cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koneill2020
Helper II
Helper II

PowerAutomate Date Condition for CurrentDate - 12 months

All, I am in need of adding a condition to a PowerAutomate which looks at the DateCompleted field whose format is in a mm/dd/yyyy format and I want to get the items from the current date - 12 months in the past so I can use this information to archoive some items to another list. Therefore what would the format of the utcNow('dd/mm/yyyy') be to get those items whose dateCompleted are 12 months (or one year old from the current date). 

koneill2020_0-1658431732794.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Blurryface
Resolver I
Resolver I

Hi @koneill2020 if you want to use an expression you could do this:

 

AddDays(utcnow(), -365, 'yyyyMMdd')

let me know if this solves your issue, thanks.
LT

View solution in original post

2 REPLIES 2
MarconettiMarco
Super User
Super User

Hello @koneill2020 ,

please refer to the following article:

 

https://tomriha.com/how-to-add-months-to-a-date-in-power-automate/

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

Blurryface
Resolver I
Resolver I

Hi @koneill2020 if you want to use an expression you could do this:

 

AddDays(utcnow(), -365, 'yyyyMMdd')

let me know if this solves your issue, thanks.
LT

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,350)