Hey guys,
I have two fields in a table namely Start_date and End_date.
Now, a user is expected to select a start date and end date on a web page. These dates should be compared with the dates in the database in such a way that the dates entered by the user are not in between the dates in the table.
For eg..
if the user enters:
Start date: 12/07/2009
End Date: 15/07/2009
The entry stored in the table is :
Start_Date End_Date
11/07/2009 14/07/2009
When the user submits, the the message should be displayed "Dates not available"
Please suggest some logic with some code.