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.
Solved! Go to 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.
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.
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
Thank you! I didn't know that we could do negative numbers with that formula. I ended up Doing this..