6 Replies Latest reply on Jan 25, 2012 3:13 PM by Alex Kerin

    Aggregation by dates

    Luis Amadeo

      Not sure if the title does justice to this post but here is what I want to do. I have a database with events by date for each of our patients. I want to calculate the number of dates between each event. A patient may have one to multiple events for each admission. I would like to create a way to show in a table the number of dates between each event. Hopefuly this will also allow me to calculate the average number of dates between events for the hospital. Sorry, I am not able to post any data here.