DateDiff

rbuser

I am trying to write a report in a software where the report builder is
Embeded into another applicaiton.

My goal is to be able to figure out the Time/Date difference between to
Dates.

I have not been able to figure out how to do this in report builder:

In another app i use DateDiff ("s",{date1},{date2})
Which returns a value in Seconds for the difference in time between the two
dates.

Thanks for any help...
Rogan.

rbuser

Not sure what your other app is, but very typical Delphi would be:

lDiff := (Date1-Date2)*86400;

HTH,

Ed Dressel

rbuser

I do most of my reporting in Crystal.

But in this instance, I am using a Ticket Tracking system with built in
reporting.

The reporter they have built into the app is ReportBuilder.

So i am guessing that i would use a Variable, and then use that equation to
return a value. Generally speaking all these TimesDiff would be less then 1
hour.

I have only been working in this software for 3 days, and i had to spend a
lot of time learning the DB structure of the new database.