How can I output a date field value as a date if there is a date value otherwise a blank field value?
Currently I have a data base where not all the records have a Term Date, formatted as 'YYYY-MM-DD 00:00:00.000'. When I output the date the blank show as 1900-01-01 00:00:00.000. If I use the convert(char, TermDate,101) statement, it is not a date format.
I want to be able to create a where clause later to filter based on the term date.
What can I do?