Finding a Date within a range

[einstein]

I'm trying to figure out a way of determing if a particular date is within a date range.  For example in the dataset below.  I want to see if Person ID 1 was covered on Oct 1, 2014.   Is there an easy way to figure this out?

Person ID           Date Begin             Date End            Program

1                          01/01/2014           09/30/2014         AD

1                          11/01/2014           12/31/2014         BB

[Reeza · Accepted solution]

Sure. How do you want to deal with multiple records per ID? Also, is it possible to have missing values? If so, the logic would need to be adjusted.

if date_start <= "01Oct2014"d <= date_end then coverage=1;
else coverage=0;

[einstein]

Thank you!  This worked out perfectly!