If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

<= filter based on date column doesnt work

Started by philelmousse, 12 Jan 2012 07:55:10 AM

Previous topic - Next topic

philelmousse

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...

philelmousse

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