I am working on a reservation system and have never worked much with time in other applications. I am using military time to input "reservations" but I need to display when an item is reserved and was wondering if anybody knows a way to check if a given time is in a range between two other times: For Example:
If giventime is between rs("restimein") and rs("restimeout")
Then do something
Is there an easy way to do this, I haven't been able to find anything that seems to apply. I am going to need to check if about 32 different times fall between the reservation in and out range. (0700, 0730...2230, 2300)
Any help would be greatly appreciated.
If giventime is between rs("restimein") and rs("restimeout")
Then do something
Is there an easy way to do this, I haven't been able to find anything that seems to apply. I am going to need to check if about 32 different times fall between the reservation in and out range. (0700, 0730...2230, 2300)
Any help would be greatly appreciated.