If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Time stamp diff in framework manager query subject

Started by KavitaPrasad, 15 Jan 2013 08:53:48 AM

Previous topic - Next topic

KavitaPrasad

Hi,

I have a open date (Jan 15, 2013 9:21:00 AM) in this format.
And a close date (Jan 16, 2013 10:05:00 AM) in this format.

I need the difference in hours. ie if the diff is 45 minutes i need it in 0.45 format
and if the diff is 1 hour 45 minutes i need it in 1.45 format.

Can anyone help me to achieve this?

Thanks