How to search between dates
From: Arun Solleti <asolleti_at_csee.usf.edu>
Date: 2000/06/28
Message-ID: <395A8C35.B0B55893_at_csee.usf.edu>#1/1
Date: 2000/06/28
Message-ID: <395A8C35.B0B55893_at_csee.usf.edu>#1/1
Hi
[Quoted] Can this be done ?
I have table which will contain the reservation schedule of an equipment in a lab. The table will look like below:
UserID EquipID EquipName StartDate EndDate xyz 123 Name1 06/28/00 10/28/00 abc 123 Name2 11/28/00 12/28/00 efg 123 Name3 05/06/01 12/04/02
So different users depending upon there needs will reserve the equipment.
If i want to search for the availability of EquipID:123, and specify a start date and end date. How should i parse through the above table, to give search results about its avilability(i.e. it is avilable from 10/28/00 - 11/28/00 and again avialable form 12/28/00 - 05/06/00 and not in-between)
Thanks
Arun
Received on Wed Jun 28 2000 - 00:00:00 CEST