.. done

Org Join Date Compare
=====================

This Condition located on the Enrollment History category tab in Search Builder
gives you the option to look at a person's join/enrollment date in
an organization (for those *currently* enrolled) compared to another date,
such as Church Membership Join Date, Decision Date, and others.
You would select Comparison and the Code
and then the Program and/or Division (and Organization, if you want)
against which you want to compare it.

The options for the comparison dates are as follows:

-  Joined
-  Dropped
-  Decision
-  Baptism
-  Wedding
-  New Member Class

All of these have a date associated with them and that is the date used in the comparison.

.. admonition:: Use Case 1

    I want to know how many people enrolled in a Life Group class and
    later made a decision to join the church.
    This is what that would look like:

.. figure:: https://i.tpsdb.com/2016-10-04_09-03-48.png
    :target: #

    Org Join Date Compared to Decision Date

In the above example, when you use the Comparison Less,
that means that the Join Date for the Organization pre-dates (is less than)
the person's Decision Date.

.. admonition:: Use Case 2

    Instead of just finding at everyone that joined a Life Group
    and later made a decision to join the church,
    you can first find everyone that has joined the church this year
    by using the Condition `Join Date` and Greater Than Equal To the first
    of the calendar year or the church year.
    Then add this Condition.

.. figure:: https://i.tpsdb.com/2016-10-04_09-10-11-1.png
    :target: #

    New Members - Org Date Prior to Decision Date



|
|

+--------------------+------------------+
| **Latest Update**  | **11/13/2020**   |
+--------------------+------------------+

Modify image link with secure protocol.