Extract Date Based On Event

[shellp]

Hello,

I have a database where one record has many events (Read, Edit and Save). I want to calculate the duration of the time from Read to Save and I originally created a table for the Saves and another for the Reads with a RowFilter field based on the record ID and coder_date. Then I linked the two tables together to get a start and end date to calculate the duration by datediff(minute,St_Date, En_Date).

This method works for cases where there is only one read/save per episode but if there is a case on the same day where the coder read/saved the same record more than once, my current methodology means that the min/max date/time of the date are used to calculate duration and shouldn't.

The methodology should be that if there is only one Read, even if multiple Edit/Saves in between, I only want to use the last date/time of the date with Save. If multiple Reads then I want each Read/Save combo even if it produces two records per account ID. Below is a table showing what I hope comes from the SQL script in terms of adding the various records to a Save or Read table.

table.jpg

Any and all assistance greatly appreciated. Thanks.

[shellp]

Just bumping this thread....can anyone assist? Thanks.