From d80e50abbebba8a3a801a7e76cf9dc096f571ffb Mon Sep 17 00:00:00 2001
From: Liz Rea <lrea@nekls.org>
Date: Thu, 4 Jun 2009 11:22:00 -0500
Subject: [PATCH] Bug 3289 - Fixed bad conditional check that made news items
 not show up until the day after pubdate.

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
Signed-off-by: Henri-Damien LAURENT <henridamien.laurent@biblibre.com>
---
 C4/NewsChannels.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm
index 136cc5c282..8cf1ff6d9c 100644
--- a/C4/NewsChannels.pm
+++ b/C4/NewsChannels.pm
@@ -328,11 +328,11 @@ sub GetNewsToDisplay {
      SELECT *,timestamp AS newdate
      FROM   opac_news
      WHERE   (
-        expirationdate > CURRENT_DATE()
+        expirationdate >= CURRENT_DATE()
         OR    expirationdate IS NULL
         OR    expirationdate = '00-00-0000'
       )
-      AND   `timestamp` < CURRENT_DATE()
+      AND   `timestamp` <= CURRENT_DATE()
       AND   lang = ?
       ORDER BY number
     ";				# expirationdate field is NOT in ISO format?
-- 
2.39.5