From 71a9c04c239acab6c27cd0020c5242bb4af3442e Mon Sep 17 00:00:00 2001 From: Justin Freeman Date: Thu, 26 Aug 2021 09:59:14 +1000 Subject: [PATCH] CIVICRM-1820 CiviCRM Scheduled Reminders, Effective Start Date and Effective End Date are incorrectly evaluated if these fields contain a value '0000-00-00 00:00:00' --- Civi/ActionSchedule/RecipientBuilder.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Civi/ActionSchedule/RecipientBuilder.php b/Civi/ActionSchedule/RecipientBuilder.php index 8871a4e6b6..2366b69fdd 100644 --- a/Civi/ActionSchedule/RecipientBuilder.php +++ b/Civi/ActionSchedule/RecipientBuilder.php @@ -409,10 +409,10 @@ class RecipientBuilder { else { $startDateClauses[] = "DATE_SUB(!casNow, INTERVAL 1 DAY ) <= {$date}"; } - if (!empty($actionSchedule->effective_start_date)) { + if (!empty($actionSchedule->effective_start_date) && $actionSchedule->effective_start_date !== '0000-00-00 00:00:00') { $startDateClauses[] = "'{$actionSchedule->effective_start_date}' <= {$date}"; } - if (!empty($actionSchedule->effective_end_date)) { + if (!empty($actionSchedule->effective_end_date) && $actionSchedule->effective_end_date !== '0000-00-00 00:00:00') { $startDateClauses[] = "'{$actionSchedule->effective_end_date}' > {$date}"; } } -- 2.25.1