Missing datetimediff function in CR 9 Dev 1

[hallux]

Greetings,

I downloaded ufldtdif.exe from crystal decisions to use the datetimediff function in CR 8.5 Dev to display total report processing time. Works great for showing customers how I am improving the report run-time from over an hour in a few cases to minutes. Now we are investigating CR 9 and see that the datetimediff function is also not in the default installation.

Is there a simple replacement for datatimediff or would it be necessary to write additional code with datediff to get the same functionality?

Or is it possible that the report processing time is a built-in function in CR 9? That would great.

-Brent

 

[Reebo99]

I've never heard of datetimediff, but you can use datediff for seconds, minutes and hours like :

DateDiff("s",StartDateTime,EndDateTime) = Seconds
DateDiff("m",StartDateTime,EndDateTime) = Minutes
DateDiff("h",StartDateTime,EndDateTime) = Hours

By the way, if you go to

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr8_formularef.zip.asp

and download the help file, it will give you the correct syntax for formulas, with examples.

Have fun!

Reebo
Scotland (Sunny with a Smile)

 

[dgillz]

DatetimeDiff is a UFL on the crystal decisions website, it is never installed by default. Download the UFL from the following URL then try it again. If it still fails, it is most likely not being registered. You can manually register it by using Regsvr32 form a DOS prompt.

Here is the download:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/ufldtdif.exe.asp

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[hallux]

Reebo99, dgillz
Thanks.
-Brent