SQL Server does not understand empty dates - make them null.
>my attempts to upload records with an empty date field resulted in SQL Server filling the date field with 01/01/1900. I don't want that so I've been trying to update the records with a blank date. All my attempts have been rejected with complaints about converting the string to a date.
>
>Anyone know the way to do it?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown