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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.