When reviewing the criteria for BluePrints there is the ability to reference On Hold Time for example.

The options are is Current Time, and Custom which is choose another date.

Is the custom time a relative time? Like when you set it to a week out or two weeks out is it always two weeks out or is it the specific date you choose? If it's the latter, I'm not sure how this is helpful. If it is the former, then I would recommend setting something up that allows custom to be less than/greater than and then a day/week/month column as well so it's current time + whatever is selected.