I am trying to get only one dates that is closer to the hiring date and not sure how to achieve it. For example:
The Hiring Date is 01/05/2016 and there are (for example) two Reviewed Dates, 03/08/2016 and 04/12/2016. I want to get one of the date that is closest to 01/05/2016 out of those two reviewed dates. How do I achieve it?
Below is my simple query:
SELECT Hiring_Date, Reviewed_Date
Current result set is:
What I need to achieve is:
Because 03/08/2016 is the closer to the Hiring_Date