Determine the current day when selecting a record

[FrontPager]

Hi,

I'm connecting to a table that has the following fields:

DayName (Monday, Tuesday, etc.)
Start (11am, 3pm, etc)
Stop (12pm, 4pm, etc)
Protocol (Instructions specific to that day/time)

Here's my SQL statement:

SELECT * FROM Protocols WHERE Start<=Time() AND Stop>=Time()

That works fine, but I also want to match Dayname to the current day.

For instance, if today is Thursday, I only want to pull the records from the table "Protocols" where Dayname is Thursday, and Start/Stop is within the current time.

How should my SQL look??

 

[Noconi]

I am not sure if this will be of much help, but I think you are going to first have to establish what the current day of the week name is - then figure out the SQL statement.

Maybe these pages I found will help get you off in the right direction:

http://www.codeave.com/asp/code.asp?u_log=53

http://forums.devarticles.com/showthread.php?t=4872

HTH
Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com