Date difference calculation

[Desperado]

Hi All,

I would like to find the date diff between two date fields. and I have to show this difference in the form of days, hours and minutes.

Like , the diff should be shown like 2 days, 12 hours, 25 minutes.. Id there any predefined function in cognos 8 to do this ... I have tried with almost all the functions. But i might be missing some where ... Any help is appreciated. Thanks in Advance

[sgyazuddin]

Hi;

When you are using Reportstudio try to go to functions(Bussiness date time function).From there you can use date functions.
To get only date from date and time date column use cast(column,date)

Think this will work out.

Thx & Reg.
S.Gyazuddin.