Difference between 2 datestimes

[Montana751]

I have to find out the hours/minutes/seconds difference between 2 datetimes. Any suggestions??

12/17/2003 3:40:09AM and 12/17/2003 3:40:33AM
12/15/2003 8:15:10PM and 12/18/2003 4:01:18PM

I have to show the difference as hours/minutes/seconds that have elapsed from the first datetime to the second datetime.

 

[synapsevampire]

Try:

datediff("s",{table.date1},{table.date2})

Then apply my FAQ:

faq767-3543

-k

 

[Montana751]

I had already tried that, but it only returns the seconds, how do I return the total hours, minutes & seconds of elapsed time????

 

[synapsevampire]

I guess that you didn't look at my FAQ, double click the link...

-k

 

[Montana751]

Thanks that worked great. Sorry for missing the FAQ, see what I get for not paying attention.