Finding something closest to current date

I am trying to figure out how I would find a data type with a date/time field that is closet to the current user’s date/time? I hope that makes sense. Let me know if you can help.