Recent SQL Date Question 1

[Trudye]

How do I write an SQL statement to get the most recent date? Is Max date an option?

Thanx much,
Trudye

 

[lespaul]

select Max(DateField) from Tablename

will give you the most recent date entered in this field.


If you need additional fields, you must also include them in a GROUP BY Statement:

SELECT USERNAME, MAX(DateField) FROM TableName GROUP BY USERNAME





Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[fredericofonseca]

And what have you tried to far? Some code please and an explanation of why it didn't return the values you expected, along with same sample data.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Trudye]

Thanx Paul. I had no idea what to use so I decided to ask. I couldn't find anytning on it in the book that I have.

Thanx again,
Trudye