Applying Filter

[Sak]

Hi All,

I'm using a date column in the report in which there are lot of blank values for the dates. I need to filter those values.
I tried using is not null function, but still it displays the blank values >:(

[tjohnson3050]

try [date column] <> ''

[Sak]

Hi Johnson,

Thanks for your reply.
I tried this before [date column] <> '', but it throws error.
The date column format is "Jul 4, 2010 12:00:00 AM".
Also i tried the below things:
1. [date column] is missing / is not missing.
2. [date column] is null / is not null.
3. created a data item and used case statement and then tried to remove the null values
case
when [EFFDT]is not missing then 'A'
when [EFFDT]is missing then 'B'
when [EFFDT]is null then 'C'
when [EFFDT]is not null then 'D'
else 'E'
end
still it doesn't help.

Any help would be much appreciated.

[absriram]

Hi Sak,

May be the blanks are not really blanks. Did you check if they have white spaces? Try this, create a new data item with this expression: length(cast([EFFDT],varchar(25))

What does it show for the blank values?

Sriram.
http://cognosonsteroids.blogspot.com

[Lynn]

what is the error?

How about this:

[Date Column] > Jan 1, 1800 12:00:00 AM