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!

  • Congratulations strongm 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. kamiel71

    Time range on specific day of the week

    Thanks!! Your suggestion put me in the right direction! Here was my final solution in case your curious :) -Kamie ((if DayOfWeek ({PAT_ENC_HSP.ED_DEPARTURE_TIME})= [2,3,4,5,6,7] then TimeValue ({PAT_ENC_HSP.ED_DEPARTURE_TIME}) < time(23, 00, 00) and TimeValue...
  2. kamiel71

    Time range on specific day of the week

    I am needing to capture occurrences within a specific time range for the week. The first 2 timevalue statements below work fine. What is giving me issue is changing the time range for only 1 day(Sun). I am wanting to only capture occurrences on Sun from 7:30am to 11pm but I'm getting stuck...

Part and Inventory Search

Back
Top