Filter Dates Ranges

DanverMendoza

Good day. 

I have a question is it possible to filter a specific range data using dates but will use the days in Alteryx? For example, I have a report that needs to be created every Tuesday and the data that needs to be filtered is from Monday - Sunday of the previous week or days.

Yoshiro_Fujimori

Hi @DanverMendoza ,

If you can feed the reporting date, you can get the start date (Monday) and the end date (Sunday) with Formula tool.

Then you can append these dates to the data, and apply filter.

Workflow

Formula

DayOfWeek = ToNumber(DateTimeFormat([Report Date],"%u"))

Monday = DateTimeAdd([Report Date], 1-[DayOfWeek], "day")

Sunday = DateTimeAdd([Report Date], 7-[DayOfWeek], "day")

Output

I hope this meets your requirement.

FilterDateRanges.yxmd