CNFS IQ- Query Builder: Birthdates Within a Date Range

Issue:
You need to create a report of all children born within a date range.

Solution:
From the IQ module, set up a new query. Add new Result Columns:
1. "Families: Last Name" and "Families: First Name" (this will be the parents)
2. "Members: Full Name" and "Members: Birthdate" (also add whatever address info you need from "Families: Contact Info")

Now go to add the Query Conditions:
3. "Members: Birthdate: is between: (your date range)"
4. "Families: is Registered: is equal to: Yes"
5. Organization: Organization ID: is equal to: (Your Org ID here)"



6. Then "Execute Query." When the results appear, create a report by:
7. Click "Query Results" and choose "Export to CSV." Save to computer.

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.