Q: When I try to enter a completion record, I get the following error message:

Microsoft OLE DB Provider for SQL Server error '80040e14' Implicit conversion from data type datetime to float is not allowed. Use the CONVERT function to run this query.

A: It sounds like you may be missing a revision record, or there may be a NULL release date. This could happen if the script to convert the database to version 12 did not finish running without errors. Try running the version 12 script again. If that does not fix the issue, check your revision records and make sure there is a record for the current revision, with a release date.

Please contact us if you need further assistance. We are here and happy to help!

Tags: Float data type, can't add completion records, error adding data.