Coalesce Date

[iolaper]

I do a coalesce(date,' ') as date
Here if date is NULL it is replaced with a blank string
But my report shows up as 1/1/1900 if the date is NULL in the database.
I tried lots of things but could not avoid it.
I want it to display a blank string if there is a NULL.

Database: SQL Server 2000
MSTR V: 7.5.1

 

[nlim]

did you try case(isnotnull(date), date, ' ')

 

[iolaper]

Know what nlim, I think it works without even having a coalesce. I removed it and since I was not filtering on the date, it still pulls in the data fine.
But I will make a note of the syntax though.