From 894bf2b759b66a977ababc3bd3ca3f8920077879 Mon Sep 17 00:00:00 2001 From: Andrew Engelbrecht Date: Wed, 14 Jun 2023 14:09:16 -0400 Subject: [PATCH] join_date is closer to actual start of membership --- board-forum-contacts.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/board-forum-contacts.sql b/board-forum-contacts.sql index c47543d..92636c1 100644 --- a/board-forum-contacts.sql +++ b/board-forum-contacts.sql @@ -19,7 +19,7 @@ and c.id not in ( ) and ( c.id in ( select contact_id from civicrm_membership - where status_id in (1, 2, 3, 4) and end_date >= '2018-01-19' and start_date <= '2022-10-19' -- was a member during time period + where status_id in (1, 2, 3, 4) and end_date >= '2018-01-19' and join_date <= '2022-10-19' -- was a member during time period ) or c.id in ( select contact_id from civicrm_contribution where contribution_status_id = 1 and receive_date >= '2018-01-19' and receive_date <= '2022-10-19' -- 2.25.1