Hi,

Welcome to SSC. Since you're new and your question isn't entirely clear, perhaps reading one (or both) of these articles will help us to help you.

and/or

Jeff Moden's article on Forum Etiquette: How to post...

The answer I've seen around here is doing a ABS(DATEDIFF ... ) between the possible answers and then take the top 1 values.