Pipeline workaround - 'is contained within'

You can do: Contains , but the reverse is not available.

is contained within the .

I think my solution may be to reverse the order of my 2 searches. At least that's all I can come up with.

This essentially is regarding my other post. I had one i idea where I searched my subcontractors, all which have a field called 'missing dates'. So it might be like "1-1-2021; 3-1-2021'

Then I search a dates table which just has dates listed. I want to say, search the date table for where the single date is contained within the missing dates field. 

I don't think that's possible, but I think i can search the date table FIRST. Somehow limit the dates to a manageable amount, then for each date find a subcontractor where missing dates contains that single date. Then finish my pipeline. 

That's my only idea so far

------------------------------
Mike Tamoush
------------------------------