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 >:(
try [date column] <> ''
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.
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
what is the error?
How about this:
[Date Column] > Jan 1, 1800 12:00:00 AM