Filter Date older than 1 week

[stephc1]

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. 

[Sundeep_Malik · Accepted solution]

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]

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')

Best Regards,

Charlie Choi

[stephc1]

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!