1. G

    Finding cases where client depart date and reentry date are less than 28 days apart

    I have the task of finding a way to find cases amongst 1,000s of clients where: a) the client has entered the system and been closed; and b) reentered the system again within 28 days of the last closure. Being a novice I used sumproduct which counts clients ebtween 2 nominated dates but I cant...
  2. S

    use a self join to find all recurrence within 30 days?

    Hello, I think I could use a self join to find each patients' admissions which can be considered readmissions within 30 days but I am wondering how to make sure that the records are compared with each properly. For example, if a patient has 5 total admissions within a year, the first one is...

Some videos you may like

This Week's Hot Topics