Sales report does not include events after 23:23:59 on the last day of a date range

[brianhogg]

Reproduction Steps

1. Place an order at 23:30 (or anytime after 23:23:59)
2. Under LifterLMS > Reporting, "Sales" tab, enter a from date in the past, and to date of today

Expected Behavior

Things like "Net Sales" and "# of sales" includes the transaction

Actual Behavior

The transaction is not included.

Tech notes

We're setting the date to "23:23:59" instead of "23:59:59" in our query

lifterlms/includes/abstracts/abstract.llms.analytics.widget.php

Lines 162 to 180 in 7dc84b5

	protected function format_date( $date, $type ) {
	switch ( $type ) {
	case 'start':
	$date .= ' 00:00:00';
	break;
	case 'end':
	$date .= ' 23:23:59';
	break;
	}
	return $date;
	}

We likely want to query for less than 00:00:00 on the day after as per this thread.