Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Filter to return previous Friday until current day.

Fred22
8 - Asteroid

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!

13 REPLIES 13
john_miller9
11 - Bolide

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

Fred22
8 - Asteroid

Amazing. Thank you very much. I will mark the solution as correct. Have a great day.

Srikanth1729
5 - Atom

Hi,

 

Thanks for the solutions, but in this case, the answer changes on the month end, depending on the number of days in the month. Isn`t it?

roshnimehra
5 - Atom

This helped me a lot.. Thanx..

Labels