Answered

Filter Date older than 1 week

(0) Share

Report

Posted on by 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.

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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!