I am generating event frames for a process (production, cleaning). I need to search by date/time for 'EventFrame1'
I then need to find the event frame previous to 'EventFrame1'.
In more common terms:
Search for the the production event for line 1 (Current) based on date/time entered by user
Search backwards for the previous production event - This is what I'm hoping there's a shortcut for.
I will then use previous End Time and Current start time to frame a new query to find a different event frame type (Cleaning).