Author Topic: How to calculate the time from 00:00 to 23:59  (Read 1313 times)

Offline inu

  • Statesman
  • ******
  • Join Date: Nov 2013
  • Posts: 426
  • Forum Citizenship: +0/-28
How to calculate the time from 00:00 to 23:59
« 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

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,803
  • Forum Citizenship: +106/-0
Re: How to calculate the time from 00:00 to 23:59
« Reply #1 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.

 


       
Twittear