How to show date rows equals current date?

Hi,

I would suggest you change the structure of your table to have 2 date columns (start_date and end_date).
This way you can use simple date functions from PHP or MySQL to built your query.

If I will change it I need to alter a lot of codes which in return will take enough time to complete. Because not only the Leave Administration needed this but also the other modules in our system.