Print Page - How to calculate the time from 00:00 to 23:59

Title: How to calculate the time from 00:00 to 23:59
Post by: inu on 29 Jul 2015 06:17:47 AM

Hi Team,

I am facing one issue. in cognos 7. If execute the report for 18-03-2014 00:00 to 19-03-2014 00:00. It fetches the data only for 18, not 19.
Because time also included with date. So I wated to calculate this filter so that it will take 24-hour format.

I used data format also , but it didnot work.

Can you please suggest me in this regard? Your valuable response will be appreciated.

Thanks and Regards
Inam

Title: Re: How to calculate the time from 00:00 to 23:59
Post by: bdbits on 29 Jul 2015 09:48:37 AM

Cognos 7? Really?? Well, that was before my time, but in general you'll either have to include the time through the end of the day (i.e. 23:59:59), or cast the data item you are matching against to just a date.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: inu on 29 Jul 2015 06:17:47 AM