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 Chris Miller 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. rnelson330

    Min/Max on formula field

    Thanks...they are datetime types. I think the cf_duration is a custom formula, but it appears to be provided by the vendor (yet again) and I can't get any information thus far on what it does exactly. I did try google but didn't see anything relevant. Times like this make an experienced guy...
  2. rnelson330

    Min/Max on formula field

    thanks LB...I actually found a formula provided by the database vendor. But, I also have this one: CDbl(CF_DURATION ({@dtOpenDate},{@dtCompleted}, "h")) which calculates the elapsed hours but it contains functions I haven't seen before and cannot really find any information on, namely the CDbl...
  3. rnelson330

    Min/Max on formula field

    Hi. I am trying to get the minimum value for a formula field (@elapsedtime) that is derived from the difference between the completeddate and opendate of workorders. I thought I was following the steps in the Help, but I get the message the remaining text doesn't appear to be part of the formula.

Part and Inventory Search

Back
Top