I think you can still do it by using the Date tab and the < > option
What exactly are you trying to filter by? Are you looking for all files created before 'Last' Friday?
I think with more context we can advocate something that does not have additional steps or tasks.
You're quite right. There is a formula for that, although if I'm remembering correctly, the simple form of it when used during the weekend will give you Friday before last. I can never remember on the first try how to adapt it to avoid that...okay, got it.
As demonstrated by changing the specified date in both places in
{DATEADD(Days|2020-07-03|yyyy-MM-dd|{MATH(Subtract|Integer|1|{DATE(WeekDayNumber|{DATEADD(Days|2020-07-03|yyyy-MM-dd|3|dddd)})}|)}|yyyy-MM-dd)}
it can be done with something like
{DATENOWADD(Days|{MATH(Subtract|Integer|1|{DATE(WeekDayNumber|{DATENOWADD(Days|3|dddd)})}|)}|yyyy-MM-dd)}
If you want it to give you
last Friday when it is
currently Friday, it gets slightly simpler; I think then this works:
{DATENOWADD(Days|-{DATE(WeekDayNumber|{DATENOWADD(Days|2|dddd)})}|yyyy-MM-dd)}
However, all that might be affected by the system regional settings for what is considered the first day of the week, depending on the internal implementation.
Here's another trick that does require an additional piece of setup but might be an improvement if the regional consideration is a concern, or if referring to an external entity will be less confusing than following the date math...set up a time exception for Friday (midnight exactly if you want checking it on Friday to get the current day, all day Friday if you want checking it on Friday to get the previous Friday) and use something like this:
{DATEADD(Days|{DATE(GetNextTimeException|<time exception collection id>|yyyy-MM-dd)}|yyyy-MM-dd|-7|yyyy-MM-dd)}
...okay I'll stop now
Edited by user
2020-07-29T15:09:53Z
|
Reason: Not specified