Simpale Date Query

[viralbhatt]

Hello,

i am stuck with simple query. how can i find oldest horse out of these?


HorseName DateOfBirth
Billy 01/04/2001
Blackjack 21/12/2000
Diamond 10/03/1999
Domino 05/06/2000
Keepagoin 02/02/1995
Neddy 04/04/2002
Waylogo 10/03/1999

 

[Brianwarnock]

Aggregate query with MIN on date of birth

Brian

 

[ScottGem]

Or sort by DOB.

 

[viralbhatt]

thank you

thank you it is working now..

i tried min before but it wasn't working

viral