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

Can this be done with Report Studio?

Started by cogb, 13 Jan 2014 03:26:41 PM

Previous topic - Next topic

cogb

Hello:

I have a date column field in my report that when null is '1/1/1970 12:00:00.000000 AM'.  I don't want this null data to be displayed, but I do want to display all other dates.  I have been trying to set up an expression for this field that will only show the result if the value doesn't match null.  Yet, I constantly get errors with the comparison.  Is what I'm trying to do possible?  I would greatly appreciate any help in solving, what should be, a simple problem.

Thanks,
Brian

cogb

I was able to figure this one out...  I had to make sure that I was comparing the right kind of datatypes.  Also, in the ELSE portion of my IF statement, I had changed it to NULL instead of ('') and it worked.  I guess it was expecting a date when I was passing a string. 

Thank you