Step by Step Way to Delete all Nodes on Certain Day?

First backup your work ...

As you consider your options, create a backup website and test out options there before deleting anything from your production website.

You can use Views bulk operations to build out a view of what you want to bulk delete.

A few years back I built a module that modifies the admin/content view with a bunch of extras (similar to the admin views module). One of the exposed filters is "Date posted" (you can also choose a date range). You can then filter for the ones created on June 14 and the bulk delete them.

https://www.drupal.org/project/admin_frosting

I just tested and the module works fine still. So you can use vbo or give Admin Frosting a go.

I'd create a custom drush command, that takes a date as an input and then deletes all nodes from that date.

First, in your custom module, add a [MODULENAME].drush.inc file.
Then, implement hook_drush_command()

/**
 * Implements hook_drush_command().
 */
function hook_drush_command() {

  $items['delete-nodes-for-day'] = array
  (
    'description' => 'Deletes nodes created on the given date',
    'aliases' => array('dnfd'),
    'arguments' => array
    (
       'date' => 'The date in YYYY-mm-dd format',
     ),
    'examples' => array
    (
      'dnfd 2017-06-14',
    ),
  );

  return $items;
}

The callback for this function will be in the format drush_[modulename]_[command] where the hyphens in the command are changed to underscores:

function drush_[MODULENAME]_delete_nodes_for_day($date)
{
  $date_parts = explode('-', $date);
  // Get midnight of the given day
  $start = mktime(0, 0, 0, $date_parts[1], $date_parts[2], $date_parts[0]);
  // Get 23:59:59 of the given day
  $end = mktime (23, 59, 59, $date_parts[1], $date_parts[2], $date_parts[0]);

  // Get all NIDs for the given day
  $nids = db_query('SELECT nid FROM {node} WHERE created >= :start AND created <= :end', array(':start' => $start, ':end' => $end))->fetchCol();

  // Loop through the NIDs and delete individually
  foreach($nids as $nid)
  {
    $node = node_load($nid);
    if($node)
    {
      node_delete($node);
    }
  }
}

Then you can call this using dnfd 2017-06-14.

Make sure you back up your database first in case something goes wrong!

Hi,
Use Bulk delete module....

It is an abandoned module. See for alternatives:

1. Views Bulk Operations
2. Delete All