Dynamic dates updates

[lbaker]

I have a workflow set up to filter for specific vendor invoices that contain specific notes that state the week the services were provided. For February, the notes are set up as 012824-020324 for the first week's invoice, 020424-021024 for the second, 021124-021724 for the third, and 021824-022424 for the last week. The filters I am using are filtering for transactions from the vendor with those specific notes (screenshot attached). I have 4 filters (1 for each week in the month) and I would like to be able to include some kind of formula that will allow me to input the first week's dates and have the remaining weeks automatically update in the filter criteria. 

For example, I would like to be able to input 012824-020324 as the filter for the first week of February and then have the next weeks filter automatically update to 020424-021024, the third week to 021124-021724, and the final week to 021824-022424. So basically, I want something that will start the next weeks date range as the last day of the prior week +1 day and then add +6 days to that date to get the final date of the period.

Is there a way to do this so that I don't have to go into each filter and update the date range manually?

[aatalai]

in the filter use theDateTimeAdd(dt,i,u) int eh expression

datetimeadd([field],1,"day")

and

datetimeadd([field],6,"day")

here is some more information

https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#idm45521471355408