Adding hours to a datetime in impromptu

[Rich72]

Hi all

I am currently trying to either add or remove a number of hours to / from a datetime in cognos impromptu but I cannot find a function that will do it.

Any help would be appreciated.

 

[griffindm]

Rich,

Just create a calculation and use the Value Interval to do this. Either add or substract the interval, which is entered as DDD hh:mm:ss.ssss.

Hope this helps.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com