COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 12 Jan 2012 07:55:10 AM

Title: <= filter based on date column doesnt work
Post by: philelmousse on 12 Jan 2012 07:55:10 AM
Hello,

I have a filter on my crosstab like this :

[LOGICAL LAYER].[Fact].[HDATE] >=
?P_Date_from? and
[LOGICAL LAYER].[Fact].[HDATE]<=  ?P_Date_to?

If I select 2011-11-30 as the P_Date_to parameter this date wont appear in the crosstab... Just until the 29 november. I also tried with a "between" but same result. I really dont understand...
Title: Re: <= filter based on date column doesnt work
Post by: philelmousse on 12 Jan 2012 08:25:04 AM
ok I check the mdx and my date was '2012-01-30 00:00:00.000'. So I just cast it in date. Everything fine now