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

Scenario: It is triggered when a string value representing a date is not compatible with the SQL DATETIME format.

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

Cause: Invalid or inconsistent date formats in the source data.

• Validate input data format against SQL requirements (YYYY-MM-DD HH:MM:SS).
• Use formulas to convert the data into the expected format: ##CONVERT, ##FORMAT.