From 2d01d4f2766f89954de49173e38cfde16bf2d5e7 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 12 Dec 2018 13:57:12 -0500 Subject: [PATCH] Correct the From and To dates being set $fromDate and $toDate need to be in correct format. --- models/front/events/list.php | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/models/front/events/list.php b/models/front/events/list.php index 2e23349..6ced97b 100644 --- a/models/front/events/list.php +++ b/models/front/events/list.php @@ -313,12 +313,14 @@ class GlmMembersFront_events_list extends GlmMembersFront_events_baseAction $startingTime = mktime(0, 0, 0, $month, 1, $year); $lastday = date("t", $startingTime); $endingTime = mktime(0, 0, 0, $month, $lastday, $year); - $fromDate = date("Y-m-d", $startingTime); - $toDate = date("Y-m-d", $endingTime); + $fromDate = date("m/d/Y", $startingTime); + $toDate = date("m/d/Y", $endingTime); + $frome = date("Y-m-d", $startingTime); + $to = date("Y-m-d", $endingTime); $this->dateRange = "id IN ( SELECT id FROM " . GLM_MEMBERS_EVENTS_PLUGIN_DB_PREFIX . "times - WHERE DATE(start_time) BETWEEN '{$fromDate}' AND '{$toDate}' + WHERE DATE(start_time) BETWEEN '{$from}' AND '{$to}' )"; } else if ( $fromDate && $toDate && !( isset( $_REQUEST['event_name'] ) && $_REQUEST['event_name'] ) ) { $from = date('Y-m-d', strtotime($fromDate)); -- 2.17.1