Pulling records between today and 1 year from today.

[sdollen]

I have a contact database where I log a client and a contact date (Client and ContactDate fields). I then compare this table to a table of all clients to find clients that have not had a contact (null).

What I'd like to do, if possible, is be able to pull the unmatched records that haven't had a contact between TODAY and 365 days ago. Any ideas?

Hope that makes sense?

Thanks for any help!

-Stefan

 

[3699wat]

Try this
Set up a query and use the following criteria
Between [now()] and [now()-365]

 

[Lightning]

Set up a query with your Client details and ContactDate fields. In the ContactDate, set a criteria

Between (Date()-365) and Date()

This should extract all records with a contact date between the current day and the equivalent date from one year previous.

HTH
Lightning