Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Time Aproximation

Hello Everybody:

 

I have 2 tables, the first has the event date, and the second has the periods when a Operator has logged in the machine. I want to associate the event date with the time period that the specific operator looged in the machine. The log data uses 1 for logging in and 0 for logging out. There are no exact matches

 

Event TableLog Table 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    What's your expect out put? User who was logging in when the event happend?

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes Sir....that is what I need