cunningham93
Registered User.
- Local time
- Today, 03:56
- Joined
- Mar 17, 2014
- Messages
- 13
Hello,
I am tracking the clean time of clients who are coming out of inpatient treatment. I am wondering how to go about calculating this in an ongoing manner in my query. If a client test positive for a substance on a given date my query will calculate the number of days from the discharge date to the positive test date (basically, I’m only tracking positive test result and if their negative, nothing is entered). What I’d like to do is to calculate in an ongoing manner the number of days clean since being discharge from treatment to today’s date unless there is a positive test result in which case it the query would calculate the number of days the person had clean between the two dates.
Thank you in advance for your help and I apologize if I’m not being clear.
I am tracking the clean time of clients who are coming out of inpatient treatment. I am wondering how to go about calculating this in an ongoing manner in my query. If a client test positive for a substance on a given date my query will calculate the number of days from the discharge date to the positive test date (basically, I’m only tracking positive test result and if their negative, nothing is entered). What I’d like to do is to calculate in an ongoing manner the number of days clean since being discharge from treatment to today’s date unless there is a positive test result in which case it the query would calculate the number of days the person had clean between the two dates.
Thank you in advance for your help and I apologize if I’m not being clear.