Page 1 of 1

Report for Clients Older Than 30

Posted: Wed Jul 19, 2017 12:02 pm
by Admin1
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.