KNOWLEDGE BASE

Error "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."


Published: 12 Feb 2015
Last Modified Date: 24 Jul 2017

Issue

When viewing a published workbook, or refresh a published data source extract using MS SQL Server, the following error might occur:

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Environment

  • Tableau Server
  • MS SQL Server

Cause

The default ODBC SQL Server driver works with many Microsoft SQL Server features, but advanced features of the newer versions of Microsoft SQL server might not be compatible with the default ODBC SQL Server driver. 
Did this article resolve the issue?