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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...
  2. kateri36

    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
  3. kateri36

    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...

Part and Inventory Search

Back
Top