Min/Max on formula field

[rnelson330]

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.

 

[lbass]

You need to show the actual content of your formula (and of any nested formulas).

-LB

 

[rnelson330]

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 and the CF_DURATION. The @fields are formula fields, of course. Can you enlighten me about those?

thanks,
R

 

[lbass]

cf_duration looks like a custom function, and I don't know what it does. Try googling it. It looks like it might return a string, since "cdbl" would convert the result to a number. What are the datatypes of each formula (date opened, date completed)?

-LB

 

[rnelson330]

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 feel like a novice. anyway...thanks for the help, I'll see what the vendor provides.

 

[lbass]

If they are just datetimes, you should be able to use the following for duration:

datediff("h",{@dtOpenDate},{@dtCompleted})

-LB