407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
Customer Area

QuoteWerks Knowledgebase Topic (Article ID 6703)

SQL - Datetime value out of range error when saving a quote

This information applies to :

Article ID
6703

Created/Updated
December 1, 2008

Category

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:

When using the Corporate Edition rehosted to SQL, a user attempts to save a quote and receives the error:

SQL Execute Error
QuoteWerks trapped error "Datetime value out of range on converting a char-type value to a datetime value (-2147217913)

Cause:

The default language of the database login account has been changed. In the known example of this error, the database was original set to use English and was set to use German after a restore.

Solution:

Reset the default language for the database login to the original language and the error should be resolved.

New Search

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)