Good Morning, Please help, I know this should be simple, but this isn't working the way I need it to. I have two datasets one looks like this: File 1 MHN DOS 111 5/6/16 111 6/10/16 111 8/5/16 Second dataset MHN Admit Discharge 111 1/1/16 7/1/16 111 2/2/17 3/2/17 What I need is File 1 returned with a flag whether that DOS falls between the second dataset. I tried to do this, but the way I have it programmed it doesn’t work, it is returning multiple records (which I get why) and it flags the one, but then looks at the second date in the second dataset and flags it as the other way. End result of what I would need is: File 1 MHN DOS Inpt 111 5/6/16 Y 111 6/10/16 Y 111 8/5/16 N
... View more