in reply to DBI, SQL and Dates

$dbhstmt->execute( '$SuStCo_strID', '$date' );

Your problem is likely to be here, single quoted scalar variables. Why do these need quoting? Remove the quotes and try it again.