DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. (SQL-22008)DBD:st_execute/SQLExecute err=-1)


$dbh = DBI->connect('Database', '******', '*******', 'ODBC', {RaiseError => 1}) or die "Database connection not made: $DBI::errstr";
$dbhstmt = $dbh->prepare("INSERT INTO ConfigTable ( strID, ModificationDate) VALUES (?, ?)");
die "ERROR: Cannot prepare statement: $DBI::errstr\n" unless (defined $dbhstmt);
$dbhstmt->execute( '$SuStCo_strID', '$date' );
$dbhstmt->finish;
$dbhstmt->finish;
$dbh->disconnect;