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

Filter Date older than 1 week

Hi,

 

I am trying to archive a working list with items older than 1 week from the main list to another one. The list has a date column. I have a formula that filters Date less than the current date, but I'm not sure how to modify the formula to subtract 1 week. Capture.png

1 ACCEPTED SOLUTION

Accepted Solutions
Sundeep_Malik
Community Champion
Community Champion

Hey @stephc1 

You can use adddays function for your case. Instead of using a positive value, use negative(-7) seven in it.

addDays(utcNow, -7,'dd-mm-yyyy')

Maybe some curly braces or something can be wrong above so do it on your own. 

I hope this helps. If you have any doubts just reply.

 

View solution in original post

3 REPLIES 3
Sundeep_Malik
Community Champion
Community Champion

Hey @stephc1 

You can use adddays function for your case. Instead of using a positive value, use negative(-7) seven in it.

addDays(utcNow, -7,'dd-mm-yyyy')

Maybe some curly braces or something can be wrong above so do it on your own. 

I hope this helps. If you have any doubts just reply.

 

v-yujincui-msft
Community Support
Community Support

Hi @stephc1 ,

 

I agree with the logic of the expression provided by @Sundeep_Malik , maybe you could try the following expression.

addDays(utcNow(),-7,'yyyy-MM-dd')

vyujincuimsft_0-1662713072696.png

 

 

Best Regards,

Charlie Choi

Thank you! I didn't know that we could do negative numbers with that formula. I ended up Doing this.. 

 

Date le 'addDays(utcNow(), -7)' and it worked!  

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!

Users online (6,493)