Forum Discussion

MuhammadP's avatar
MuhammadP
Frequent Visitor
3 years ago

Nearest Record Search based on Date

Hi,   I have a table of events with the structure below. Each event has a file number, an event code, user and date and some of them are exception events (based on some other logic that's on the Is...
Need Help
danextian's avatar
danextian
Super User
3 years ago

Hi MuhammadP ,

 

How do you know which event comes first? If we were to base in on Even Date, there are rows with the same timestamps

 

MuhammadP's avatar
MuhammadP
Frequent Visitor
3 years ago

Hi danextian,

 

Thanks for your response.

 

In my use case it doesn't affect the outcome much since it's usually the same user creating the event if the timestamps are the same. I just consider the first match.