Mid month Data Refresh

[clarrock]

Hi,

My table currently looks like this:

Roll	name	closed date cob
1	abc	2021-03-05
2	edf	2021-03-09

This file is daily file that take previous day's data and keeps adding new closed name records along with cob dates so if it was today's run cob date would be . How do I create a workflow such that my run on 2nd day(cob 1st) or 17th day(cob 16th) of the month alteryx REMOVES all the previous days data in the input file ie from 16th to 30th closed date cob records on the second days month run and data of cob 1st to 15th on 17th day month run. Is this possible?

Also it should only include working days - Sunday's and Saturdays are excluded.

Please help

[RolandSchubert · Accepted solution]

Hi @clarrock ,

you could use two Filter tools and DateTime functions to solve the problem. First Filter tool could cover the condition "1st to 15th" or "16th to last",
the second Filter should remove weekend days.

Let me know if it works for you.

Best,

Roland