SQL Server doesn't support empty datetime values. Use NULL instead.

>SQL Query Analyzer reports "Syntax error converting datetime from character string."
>
>It doesn't like the empty datetimes. How do I insert an empty datetime?
>
>

>insert into commits
>  (donedatetime, invdate, duedate, fromdate, todate, invoiceid, oldetype, discnotes,
>   batchid, adjamt, isci, dayofwk, userid, refnum, statname, status )
> values ('07/30/2004 10:54:45', '06/01/2004 00:00:00', '07/01/2004 00:00:00',
>         '  /  /       :  :  ', '  /  /       :  :  ', '1927-01             ',
>         ' ', '', 'AO0NBDRX', '0', '               ', '  ', 'JVILLAGOMEZ         ',
>         '4003978', 'WUPW      ', '1')
>