Link to home
Start Free TrialLog in
Avatar of JYnet
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.
Avatar of tleish
tleish

Do you want to do this in SQL or ColdFusion?  Also, what type of database are you using?
Avatar of JYnet

ASKER

i am thinking of using coldfusion query to check the table in microsoft access.
:-)
Avatar of JYnet

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.
ASKER CERTIFIED SOLUTION
Avatar of rac13
rac13

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks. :)