About robertvroom

robertvroom · ‎09-22-2019

Thank you SASKiwi, I will try this first thing tomorrow morning.

robertvroom · ‎09-21-2019

I would need to note overlapping dates so they could be checked individually. Times where the dates overlap should be rare. This would be similar to a hotel stay. You check in for a period of time, and in that time you sign up for activities. It would be rare for an activity to start before or to extend past the hotel stay. If the dates are 01/01/2019 - 01/31/2019 01/20/2019 - 02/15/2019 I would want to look at it individually. If the dates are 01/01/2019 - 01//31/2019 01/01/2019 - 01/31/2019 I only care about one of the date ranges. I need to know the person was with us during a time frame, and that is all.

robertvroom · ‎09-21-2019

Where I work, a person might stay for a month, and do a few items within that month. I am trying to figure out only the first and last date of the stay. As an example, Member 1 has the following cases... Case 1 Started 01/01/2019, ended 01/31/2019 Case 2 Started 01/03/2019, ended 01/04/2019 Case 3 Started 01/14/2019, ended 01/18/2019 Case 4 Started 02/15/2019, ended 02/20/2019 Since Cases 2 & 3 took place within the timeframe of case 1, I do not want them to be part of the final data. I only want to return cases 1 and 4 for this member. How can I best do this? Thank you for any advice you can provide.

Online Status	Offline
Date Last Visited	‎09-22-2019 12:41 PM

Re: Eliminating unneeded admission and discharge dates

Re: Eliminating unneeded admission and discharge dates

Eliminating unneeded admission and discharge dates

Re: Eliminating unneeded admission and discharge dates

Re: Eliminating unneeded admission and discharge dates

Eliminating unneeded admission and discharge dates