Ignoring the Time by Creating a Hi-Low Filter

You can create a hi-low filter to ignore the time. In the IBM® Cognos® Framework Manager model, create a filter in the form date-column between date-lowtime and date-hightime. For example, the following expression returns all values between 00:00:00:000 and 23:59:59:000 for a given day:

[SCOTT_TIGER].[DATES].[COL1] between?p1? and cast(substring(?p1?,1,10),'23:59.59.000',timestamp)