Availability dates in offering dates except booked dates
For Example:
Offering dates are :
01-09-2005 to 27-09-2005
01-11-2005 to 30-11-2005
Booked dates are :
10-09-2005 to 23-09-2005
Availability dates should be
01-09-2005 to 09-09-2005
24-09-2005 to 27-09-2005
01-11-2005 to 30-11-2005
I am storing offering dates and booked dates in a table as DATE datatype using MYSQL.
So, I want the above mentioned availability dates as a result.
Please find the way and let me known its very urgent...
warm regards
Naveen
