I have a circuit path connecting two locations

madrid and Barcelona

Madrids ckt name is MD989

Barcelona Ckt name is BL111

I want to calculate from the raw dump when these both circuits were down at a single time.

data provided is

ckt name |Ckt start date|ckt down date .

i want to check for a particular circuit when it was down..just need ot to return 1 if both the ckt`s were down at a single instance