check event time between start and end
Posted on 2001-06-27
hai, i have a table called event
it contains an event name and start time and end time
if i add a new time to process (in another table), is there anyway to check whether it is within the event time or not?
eg. event A start at 10am to 2pm (store in event table)
i want to add a time, but the computer need to check event table whether there is any event exist, and also check the time.
if i input 11am, since it is within 10 to 2 pm, so cannot
but if i input 3pm, it can be done.
how the programming will look like?