interval match with two dates

[mstoler]

Hello,

Is it possible to do an Interval Match with two dates.

1. An Order Date in a specified date range.

2. A Delivery Date in a specified date range.

I have a Order Date and and Delivery Date field in my data along with an Order date target range and Delivery date target range.

Thank You,

Michael

[Digvijay_Singh · Accepted solution]

I guess the process needs to repeat for each date and date range, are you having separate interval tables having from-to range for Order Date and Delivery Date?

[mstoler]

Hello,

That is my thought. 

Just do the first match.  What makes it past the first match then use the second match.

Michael