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 Wanet Telecoms Ltd 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 kateri36
-
DateTime help
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...- kateri36
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Employer's First Report of Accidental Injury or Occupational illness
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- kateri36
- Post #7
- Forum: Business Objects: Crystal Reports 4 Other topics
-
DateTimeField-Need Specific Date for a Specific Time Frame
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...- kateri36
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
