Bjhogan is right. It think this has something to do with the datatype conversions like smalldatetime and datetime conversions and some times could be due to entering NULL values for the datetime columns. Try to check the code.

Thank You,

Best Regards,

SQLBuddy