Hi, I have a dataset similar to the one below. For all cases where there is an Alarm1, I want to find out if an Alarm2 occurred within 60 minutes PRIOR to the Alarm1. Hope this makes sense 🙂 I have tried using intck and intnx functions, but they always return one record. I can't find a way to scan all records that are 60 minutes PRIOR, when Alarm1 =1. Any ideas on how to make it work? Thanks so much! ptID Alarm1 Alarm2 Time 01 0 1 02APR08: 22:10 01 0 0 02APR08: 22:15 01 1 0 02APR08: 22:25
... View more