Hi @Stretlow
This thread is very old and I doubt this is still an issue but this trick may help others.
It sounds like the date fields may be defined inconsistently in your database tables. This would explain why it would work differently for various columns.
It may help to take a look at them using SQL Server commands. Here is an example using everyone's favorite table - cars.
libname mssql sqlsvr complete="Driver={SAS ACCESS to SQL Server};
HOST='mysqlserver.mycompany.com';
UID=myuserid;PWD=mypassword;
DB=test";
data mssql.cars;
set sashelp.cars;
run;
/*
Use explicit pass-through to see how the columns are defined in the database.
*/
proc sql;
connect using mssql;
select * from connection to mssql
(exec sp_columns cars);
quit;
This is the output...
... View more