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

Format time interval as minutes without the unit 'minutes'

Started by blom0344, 29 Nov 2007 04:15:02 AM

Previous topic - Next topic

blom0344

When subtracting 2 timestamps (Oracle dates) I want to format the outcome in minutes , but without having the unit 'minutes' displayed in reporting tools.
Is this possible (or do I need to code it with native functions?)

blom0344

Turns out the customer wanted to have the numeric output for saving as Excel. So we coded it as an Oracle expression.
I'm really impressed with all the pre-formatting that Cognos provides, but sure wish to know how to crack this by a Cognos native solution..

hittony

Hello :)

I don't understand how the pattern works either for a time interval. I tried putting in HH:mm into the pattern property, but I got HH:mmHH:mm303059 milliseconds :o

The final format should be mm before the unit abbreviation 'm' instead of 'minutes'. So I reset and defined the Time unit to Minutes, i got 5 minutes.
Rest again and I defined the Time unit to Time, Display minutes to Yes, Display Milliseconds to No, i got here 05 ???

Anyone could help us ?

Thx ;)