I have a set of data where a client can have a given status - such as LAC - that is represented by a start date and end date eg: LAC_StartDate, LAC_EndDate
These clients (identified by a unique ID) can have lots of contacts, what I need to do is mark a contact with a flag if it took place within the LAC status period for that client, and only that client.
I did a search and found lots of interval match references for linking dates to general periods, but I couldn't find anything to link a date filtered by client, to a period filtered by the same client.
It took me a while to create some random data in roughly the format I need.
I've attached a qvw.
I've had a good look at extended intervalmatch, but I'm not sure it's what I need as I already have the contacts linked to another range.
I'm looking to show anyone with a LAC referral open during a contact_quarter I pick, that also had a contact with another service, during that same quarter, and also while the LAC referral was open. I haven't included any here, but all the referrals may have empty end_date's ie: still open.