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!

Recent content by kamiel71

  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