bigest date in the date field

[Faisal]

How to find Bigest date in a date field for a query.


As i use max() function in date field it give any error message:Cannot have
aggregate function in WHERE clause <clause>. (Error 3096)


Regards
Faisal
Riyadh

 

[John W. Vinson]

How to find Bigest date in a date field for a query.


As i use max() function in date field it give any error message:Cannot have
aggregate function in WHERE clause <clause>. (Error 3096)


Regards
Faisal
Riyadh

This may be a better case for a Top Values query:

SELECT TOP 1 <whatever fields you want to see>
FROM tablename
ORDER BY datefield