yes .. because we may have 2 events on the same day and i will need to display the first one till maybe noon and them i need it to switch to the next one.
So compare the display_datetime with the current date time..?
If you want it displayed until tomorrow (24-Oct-07) 1:36pm then, as r937 has pointed out, store the full datetime value i.e. 2007-10-24 13:36:00.000
your table contains past and future events, correct? i mean, in the context of the current datetime Now(), which i think you'll agree you'll never actually hit, so each event is either on one side or the other of it, yes?
is it fair to say that you want just the next upcoming event?
that's actually easier than it looks
select top 1
where Display_DateTime > Now()
by Display_DateTime asc
you can remove the separate date and time columns from your table too
Ok .. yes the database will have past and future events in it. Lets say that i have an event coming up on november 1st but i want to begin dispalying it today and then on november 2nd i want it to change to the next event.
I think we agree on that part. But lets say i have an event on november 1st at 8:00 am and another one at 12:00 pm. I need it to change to that next event at 8:01 am.
Thus I have the Display_DateTime field. The Display_DateTime field is never displayed it is only the criteria to base what is displayed and when.
The Event_Name, Event_Date, Event_Time, Event_Location and Event_Info are the fields that will actually get displayed.
If we happen to get to the end of the database and there are no more records and all events have been displayed it will say "There Are No Events Scheduled"
So what i am looking for is a way to make this happen.