Important Notice: This article applies to the New ParishSOFT Platform. If your diocese hasn’t migrated yet, explore our knowledge base for relevant resources.
In the Intelligent Query module, begin a new query by selecting the fields to have on the report.
For simplicity's sake, in the example below only four fields were selected: Family DUID, Last Names, First Names, and Date Unregistered.
Simply find the fields under Column Picker (on the left) and drag them to the Result Columns, or select to begin adding result columns.
Next, add the Query Condition by dragging or selecting the condition field named Date Unregistered to the Query Condition (bottom right).
Click on the operator field (which always starts off as is equal to)and change it to custom period.
The field will automatically change to within.
Click on the date before and; enter the first date in your date range. Next, click on the field after the word and; enter the last date in your date range.
The entire query build should look like the image below:
Check off Unique Records Only to avoid duplicates.
Click the Execute Query button. Export the results to a CSV file, if necessary:
Updated