I've managed to at least get CONVERT to work in the SELECTCMD of my cursoradapter so I can pull the date as a char based date (no time). It'll still pull a null if the SQL Server datetime is a null.

There must be a better way!