if ( ($DATE =~ /month/) || ($DATE =~ /day/) ) {
  $statement = "DATE(NOW()+ INTERVAL $DATE)";
   } else {
   $statement = "$DATE";  #assumes YYYY-MM-DD
}

##</code><code>##

INSERT into table (thisdate) VALUES ("$statement") WHERE id=1