For instance, a client may have a total of 20 visits, and I need to figure out the days between the first Kept visit and the second scheduled visit.  Additionally, need to add other paramaters such as days between first kept therapy appointment and first scheduled medication appointment.

 

activitydate_d, activity_c, recipient_c, clientcode_c

 

Any help would be appreciated.

 

Thanks :)

 

Number of days between

 

activity_c = "0110" and recipient = "KEPT"

 

and

 

activity_c = "0116" and recipient is (any value)

 

So, if the intake was kept on 7/01/2012 and they had a therapy appointment scheduled on 8/12/2012 - how to calculate the number of days that have elapsed between.

 

I don't usually have a hard time figuring this stuff out, but for some reason this scenario is throwing me off and I can't seem to wrap my head around it :/

 

Thanks for the feedback :)