I am in the process of creating a query for an SSRS report that will show a column that has DATETIME values. The column can have
NULL values. In my query I would like to use a
I want to create this column to just display the date and time value if its not null but if its
NULL I want it show something like 'No Data'.
The Expression I have is:
Case When (Column with Date/Time) is not null then (Column with Date/Time) When (Column With Date/Time) is NULL then 'No Data' End AS Column A
However, this query returns an error:
Conversion failed when converting date and/or time from character string.
I guess because it can't have a string value with a column formatted for Date and time?
Is there any way I can combine these two? If not I know I can leave it as is and just show the
NULL value, but I wanted it to look cleaner.