Print Page - Displying the Date difference in Days and hours format.

Title: Displying the Date difference in Days and hours format.
Post by: Mpotla on 01 Apr 2012 06:51:23 PM

Hi,

I have requirement to display the age of the request raised from Request start and end dates, which are date time fileds.

I am able to calculate the difference using calculation (Request start - end dates), which is resulting output in the format given below.

18 days 1 hour 27 minutes 57 seconds 746 milliseconds

But my user want to see the output till days and hours only.

Please suggest us, how to remove the minutes ,seconds,milliseconds from the output.

I wil be exporting the data to Excel.

Thanks in Advance.
mc

Title: Re: Displying the Date difference in Days and hours format.
Post by: colt on 02 Apr 2012 02:17:40 AM

Use Data Format - Time Interval. There you have many options to specify format you need.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Mpotla on 01 Apr 2012 06:51:23 PM