could anybody guide me , how to find that a date exists in between two dates ?
For example : 23/09/2008 -- 28/09/2008 - I'am on leave.
When a attendence is entered for the date 24/09/2008 , then i should get a msg saying, that the given date exists in the leave date.
In a leave table, i already store the above two dates and save. I will enter the attendence in the front end