1182146 - Error: "Error during SQL execution (DA0003)[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.242" when you try to refresh a query based on a date in S

You receive the following error when you try to refresh the query:

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

You are unable to successfully refresh a query that works in one environment but not in another. For example, the date was displayed in American format for the user that is unable to refresh the query and Australian/British format for a user that can successfully query the data. This scenario may differ depending on the format of the actual database.

13570 , , KBA , BI-BIP , Business intelligence platform , How To