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