JYnet
asked on
check event time between start and end
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?
thanks.
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?
thanks.
Do you want to do this in SQL or ColdFusion? Also, what type of database are you using?
ASKER
i am thinking of using coldfusion query to check the table in microsoft access.
:-)
:-)
ASKER
but what if the event table has option to be add or delete, so i may add another field called date inside the event table.
if something match the date in event table, it will check for start time and end time.
anything within start time and end time will not be processed.
if something match the date in event table, it will check for start time and end time.
anything within start time and end time will not be processed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks. :)