Print Page - Filter not working

Title: Filter not working
Post by: rams143 on 23 Mar 2011 10:39:44 AM

There is field in database, its data type is Timestamp with Timezone
and I pulling it into FM and change the format to just display timestamp without Timezone
but when I am using that in the query studio the filter is not working on that field
any thoughts? :-\

Thanks,
Rams.

Title: Re: Filter not working
Post by: blom0344 on 23 Mar 2011 10:52:28 AM

Applying a filter does not reference the format. If you want to filter on the date (without time component) then cast the timestamp to a real date

Title: Re: Filter not working
Post by: rams143 on 23 Mar 2011 01:44:36 PM

Thanks Blom. That worked.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: rams143 on 23 Mar 2011 10:39:44 AM