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

    Calculate Days Worked and Days Off

    This has resolved my problems, thanks TONS for the help.
  2. Nimisis

    Calculate Days Worked and Days Off

    Enlightenment! Thanks. I am a novice at best. Could to type the complete part for trunc(allhistory.`fromtime`)? I tried truncate (allhistory.`fromtime`) but get an error on (allhistory. Thanks
  3. Nimisis

    Calculate Days Worked and Days Off

    oops, failed to answer your question totally, the format for both appear like this: CDateTime (2005, 04, 17, 20, 09, 34)
  4. Nimisis

    Calculate Days Worked and Days Off

    Rarely but yes. Every once in a while, trips will last more than a day (ovevernight trips) where drivers may stay in hotel and return following day. The {allhistory.TimeDone} shows the time the driver is placed off-duty.
  5. Nimisis

    Calculate Days Worked and Days Off

    In Transportation business and use SQL Server with CR 10. I am working from data from a table that shows: {allhistory.FromTime} //pickup times {allhistory.TimeDone} //Time rides completed {allhistory.DriverName} //driver names {allhistory.RideID}. //confirmation numbers of trips ran by driver...
  6. Nimisis

    Need to be able to select a blank date field, but how?

    I am seeking a formula for {allhistory.FromTime}. I need to count how many days ({allhistory.DriverName}) did NOT work. Running CR 10. on SQL server.

Part and Inventory Search

Back
Top