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

    DateDiff Function Over a year

    Are you having problems with every date that goes over a year? or just one that is over a year but all the rest are ok that go over a year? Are you getting back an negitive #? I was having problems with minutes over a day and solved my problem by making two datediffs. If you are gettin a...
  2. dperk001

    Time Difference Problem

    lbass, Thanks for the tip, I tried to concatenate //{@requestdatetime}: {wo.requestdate}+{wo.requesttime} //{@completiondatetime}: {wo.completiondate}+{wo.completiontime} but it asked for a number for wo.requesttime and wo.completion time. I tried to put in TimeValues and still nothing. I then...
  3. dperk001

    Time Difference Problem

    Thanks for the "n" I fugured "s" was for seconds, "d" for day but I had no clue what was for minutes, letter "n" sounds good since you can't use "m" do to it's taken for months. I believe the negitive is because it is based off minutes in a day. my start time in minutes would be 1389 my ending...
  4. dperk001

    Time Difference Problem

    First Thanks for all the help this forum brings! I try to read the archives and have already gained alot of knowlege, but I am still stuck with a problem. Here is my problem. I have work orders that are time stamped. Some work orders are created that over flow to the next day. I need to...

Part and Inventory Search

Back
Top