I have a criteria written as
>=DateAdd("h",7,[Start Date]) And <=DateAdd("h",19,[End Date])
this works great but I now need to do one from 7AM-7:15PM. How can I change my criteria to state that?
I will do my best here to explain myself, this is my first post in this forum so be sure to tell me if I am not following procedure. I have a query that pulls data from an ODBC link. It pulls all calls in according to the date I enter (parameter: >=DateAdd("h",7,[Start Date])And<=("h",19,[End...
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.