SQL Is it possible to specify in the query, so that I can get all the employees who have less than 14 days left before the start of the vacation date before today's date?

Question

MySQL

Is it possible to specify in the request, so that I can display all the employees who have less than 14 days left before the start of the vacation date before today's date
? Can be an example.
**There is a Table in the database - "Vacation" and it has a field date of vacation.**

Answer 1

SELECT 
  * 
FROM 
  furlough 
WHERE 
  date BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 14 DAY);