SQL / PROGRESS Blank in place of NULL Date

I am trying to replace a NULL date with a blank. I end up with invalid date string. Ive Tried COALESCE, ISNULL, IFNULL, CASE STATEMENTS and nothing seems to work. I am querying a LINKED PROGRESS ODBC connection and using

declare @Data varchar(max)
set @Data= N'
SELECT MyCode
FROM TABLE
'
exec (@Data ) AT PROGRESS;


Ive done this many times before, I can do ISNULL, COALESCE etc just fine on all my other fields, but not the case with this Date field. Any help is greatly appreciated

Continue reading...