TV Guide Database (1 Viewer)

[Treason]

I am trying to write a query showing me all tv shows on right now.

The design of the tables are unchangeable because they are given to me.

The 2 important fields in the Schedule table are:

time (which is a date/time value, for when the program starts ex: 2/3/05 8:30AM)

durations (a number giving the program lenght in minutes ex: 60 (1 hour)

I want to write a query showing me what is on right now, then problem is I do not want to use MSAccess functions like DatePart or Cint ect... because the SQL from this query will be used through on a webpage using a jscript activex ADO connection and I dont think Functions like DatePart() are supported.

Thanks

 

[Pat Hartman]

Where YourStartDate <= Now() and DateAdd("n",YourStartDate, ProgramLength) >= Now();

Hopefully you can use the DateAdd() function or the SQL equivalant.