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

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

Part and Inventory Search

Back
Top