Date and Time closest to current date and time

Does anyone know how to do a search for a Date and Time closest to the current date and time without going over? I have an events app and I want to display the next upcoming event. I am trying to search for a list of events the user is attending and find the event whose Start Time is closest to the current time without going over. I am trying to figure out how the search logic would work. Something like ((MAX(List of Events Start Time))<Current Time). I am just trying to figure out how to say it in bubble language.