Parsing a weeks work of data

[Petersenk]

Here is the challenge:

I need to dynamically create a begin and end date for report parameters.

For this example:
-I create dates in the input data.
-I convert the date so I can use the Alteryx date filter.
-I filter out the dates I need in the report.

I would like this this to be dynamic because I want to schedule this to run every week on Monday.

-The begin date will be the Friday from two weeks ago 05/19/2017 00:00:00. (see the Date Filter example)

-The end date is the following Thursday at prior to midnight 05/25/2017 23:59:59.

I have used a formula to derive a month for a report, but, I cannot find anything on creating dates like the example above.

Can anyone point me in the right direction?

[BenMoss]

Hi Petersenk,

It's pretty late UK time but if no one picks this up over in the US today i'll take a crack at this tomorrow.

I think you would have to use a traditional filter tool to achieve your desired result.

Ben

[BenMoss]

Hey Petersenk,

I've given this a go, it's probably not the optimal way of getting your desired result and may need some tinkering but given the conditions you have outlined I believe it meets the criteria.

Please let me know if this works for you.

Ben

[Petersenk]

Thank You Ben!  I will give this a shot.