Hi, I have a scenario where documents get logged with a time field in ISO8601 format, a unique ID, a status, and 5 other fields. The status field will contain either an ONLINE or OFFLINE status. I would like to know the time difference between the document with the online status and the document with the offline status. After reading Comparing date/time from two different documents and seeing the functionality I was looking for is not possible I wanted to know if a different approach was possible. In short is it possible to create a third document with a field containing the elapsed time between the first two documents using a script? Or perhaps update the first document with the second one and replacing the time field with an elapsed time field?
Thank you