How to calculate the time from 00:00 to 23:59

[inu]

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

[bdbits]

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.