Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FrontPager

    Determine the current day when selecting a record

    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...
  2. FrontPager

    Links based on Day and Time?

    I'd like to base the target of a link on the day and time a user clicks the link. For instance, link &quot;Continue&quot; would bring up page Open.htm 8am to 5pm M-F, and Closed.htm at all other times. Any suggestions?

Part and Inventory Search

Back
Top