Friday Date Output

[clarrock]

Hi,

How can I output dates that always gives the previous Friday date

Eg if today is 2021/01/30 then the output  would be 2021/01/29

Such that with any days run it would give the previous Fridays date. If it runs on a Friday it should give current date

Is this possible? 

[Qiu · Accepted solution]

@clarrock 

Yes, Sir.😁

[AngelosPachis]

Hi @clarrock ,

I've used a generate tows tool to generate all dates from today until the previous week (past 7 days). Then with the formula tool you can get the day of the week and filter to only keep a Friday.

Every time you run the workflow, the generate rows tool will dynamically update today's date, so there is no need to make any changes to the configuration of the tool.

Hope that helps,

Cheers,

Angelos