AnsweredAssumed Answered

Find previous event frame

Question asked by DonKiser on Oct 1, 2020
Latest reply on Oct 1, 2020 by DonKiser

Using PIOLEDBENT

 

 

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).

Outcomes