DateDiff but returning TIME aswell

[Steve95]

Hi All

does anyone known how to a datediff on two datetime fields
so the returned value not only calculates the days but also the "h,n,s"

Thanks in Advance

Shin

 

[chris777]

You use different Interval Type Values in your datediff function to get each one back.

For example, to get days: datediff("d", {Table.Datefield1}, {Table.Datefield2}) would return the number of days. If you change the Interval Type to "h" you get hours, "n" is minutes and "s" is seconds. You then have to format and compbine them as text into the format string you want.

I hope that's what you were looking for???


If you wanted something to do it all in one pass, I don't know about that.




Chris
Data Intelligence Group

http://www.digus.com

 

[Steve95]

Cheers Chris appreicate your help..........

Many Many Thanks.....