Hi Everyone,
How do I calculate the time difference between two date/time timestamps that are in the same field, but use different codes. The fields are linked by the same event number.
For example: EMS arrived at the hospital (incilog.transcode= "H") at 02/28/2017 15:00 (incilog.timestamp (DateTime)) and cleared the hospital (incilog.transcode= "C") at 02/28/2017 15:25 (incilog.timestamp (DateTime)). EMS were on scene at the hospital for 25 minutes.
I can't figure out how to find the date difference between the two dates because they utilize the same table.field with different codes.
Any help is greatly appreciated.
Thanks,
Kim
How do I calculate the time difference between two date/time timestamps that are in the same field, but use different codes. The fields are linked by the same event number.
For example: EMS arrived at the hospital (incilog.transcode= "H") at 02/28/2017 15:00 (incilog.timestamp (DateTime)) and cleared the hospital (incilog.transcode= "C") at 02/28/2017 15:25 (incilog.timestamp (DateTime)). EMS were on scene at the hospital for 25 minutes.
I can't figure out how to find the date difference between the two dates because they utilize the same table.field with different codes.
Any help is greatly appreciated.
Thanks,
Kim