report based on 30 days

[kellan4459]

I need to develop a report that will check the database for all names who have not had an evaluation in the past 30 days. The tables are linked by Social Security Number. They have multiple evaluations
per person.

 

[OSCSLeo]

Generate a query based with the following criteria
Evaluation Date field
< Date() -30

This will show you dates of evaluations greater than 30 days from todays date.