How to get most recent Date.

[needadvice]

I have a query to run a report that selects dates more than 650 days old. The user wants only the most recent date of the dates more than 650 days old. How do I build this into the query design?
Any help appreciated.

 

[dodge20]

check out this thread

thread701-521271

Dodge20

 

[scriverb]

This SQL will give you the most recent date of dates in a table that are more than 650 days old:
SELECT Max(A.YourDateField) AS MaxYourDateField
FROM tblYourTablename as A
HAVING (((Max(A.YourDateField))<DateAdd(&quot;d&quot;,-650,Date())));


Let me know if you need more from this query.

Bob Scriver