I'm trying to do the same thing. I have a date parameter and I need to pull info from 7am to 3pm for a particular shift.
Crystal v8.0 / SQL DB
Here's my select statement:
{vw_oc_sel_allprsnphone.OnCallFromDate} in
datetime({?Date},7,00,00) to datetime ({?Date},3,0,0)
and...
Hello, I've just received the same request to create the "First Report of Injury" for Colorado & I'll be retrieving the data from Peoplesoft.
Have you created the report for Colorado?
Elaine/Children's Hospital-Denver, CO
I have a database that has all physicians on call for a specific date & time. I need to create 3 different reports for the following shifts 7am-3pm, 3pm-11pm, & 11pm-7am(next day). My formula appears to be working for the 11pm-7am(next day)but it does not display all data, some appears to be...
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.