Report for Clients Older Than 30

Discussion related to our web based product and how it works with phones, tablets, or any web browser. Discuss all questions related to the client and server side as well as setup and installation.
Post Reply
User avatar
Admin1
Site Admin
Posts: 222
Joined: Tue Jun 06, 2017 12:03 pm

Report for Clients Older Than 30

#1

Post by Admin1 » Wed Jul 19, 2017 12:02 pm

The Advanced code is: int(val(datestoage(card.birth_date, date()))) > 30

Example:

1. Click Search For A Case
2. Click the Clear Button
3. Type O for the Case Status so that any status that starts with O will be selected (Open cases only).
4. Check the Primary Names Only checkbox.
5. Click Search, Click Yes to continue.
6. Click the Search By and select Last Name (not last name quick)
7. Click the Advanced button at the lower left and enter the following:

int(val(datestoage(card.birth_date, date()))) > 30

Another example would be if you wanted all clients who are older than 30 and less than 50 then enter the following:

int(val(datestoage(card.birth_date, date()))) > 30 and int(val(datestoage(card.birth_date, date()))) < 50

8. Click the printer icon on the toolbar or Right Click it to preview.
9. Select 2 or 3 column mailing labels or a report.

Post Reply