3587404 - Error:"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" appears when running a WEBI document

Scenario1:

• When refreshing a webi report on SQL server containing datetime, the error appears: "The following database error occurred: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting date and/or time from character string.. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)""

Scenario2:

• When refreshing a WEBI document based on a universe using SQL Server database the bellow error appears:
  The following database error occurred: [SAP CrystalReports][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. For more information, refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901).
• Issue is only happening with certain dates eg: 31/12/2022.
• Issue doesn't happen when using date : 11/12/2022.

• SAP BusinessObjects Business Intelligence platform 4.x.
• Web Intelligence
• SQL Server

datetime, out-of-range, date, MDY, DMY, conversion , KBA , BI-RA-WBI , Web Intelligence , Problem