Filter to return previous Friday until current day.

My data is comprised of tickets from the beginning of time. It is updated each day but we only want to return the previous Friday until the current day. For example: Today is Monday February 12th. When my flow is ran it should only return data from Friday February 9th until now. The date column is in a format of Month Day Year: 2/12/2018.

Thank you!

Common Use Cases

Accepted answers

john_miller9

See the images of my formula and filter tool configurations attached.

From Previous Friday - Formula.PNG From Previous Friday - Filter.PNG

john_miller9

That's correct - if you run the workflow on a Friday it will only keep data from that day.

All comments

john_miller9

@Fred22

This will give you the date of the previous Friday for each date in your file, and then filter to those records since the previous Friday. This workflow keeps the past 8 days if Today is a Friday. You can adjust that in the filter though if you expect to only keep Today's records if it is a Friday by lowering to 7.

From Previous Friday.PNG

From Previous Friday.yxzp

Fred22

Hi John,

Thank you for the input. This looks like it would work perfectly but I am running Alteryx 10.6 and it won't let me open your file. Anyway you could send the file in a different format or the formulas?

Thanks again!

john_miller9

Sure - see the workflow and input attached

Sample Dates.xlsx

From Previous Friday 10.6.yxmd

Fred22

Hi John,

When trying to open alteryx it says there was an error because the document was created by a more recent version of this application and cannot be read.

Any suggestions?

john_miller9

See the images of my formula and filter tool configurations attached.

From Previous Friday - Formula.PNG From Previous Friday - Filter.PNG

Fred22

Hi John,

I almost have it working. My only issue I am running into is I need to pull everything since last Friday including Friday. With your formula and filter I am getting everything since Saturday Feb 10th. If it can include Feb 9th too it will be solved.

Any suggestions? Thank you very much.

john_miller9

Ok - try this in the formula tool for Previous Friday

DateTimeAdd([Date],
	Switch(DateTimeFormat([Date],'%a'),0,
		'Sat',-1,
		'Sun',-2,
		'Mon',-3,
		'Tue',-4,
		'Wed',-5,
		'Thu',-6),
	"days")

Dsimps92

You sir, rock.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335