select statement to get max year

• finney1969

  SSC Veteran

  Points: 227

  More actions

  July 31, 2002 at 5:06 pm

  #79545

  I am new to T-SQL and need help writing a statement. I have a table that that has multiple dates for one person. ie: 01/14/2002,01/08/1999,01/20/2000,01/30/2001. I need to get the most recent date which would be 1/14/2002. When I use the MAX I get the 1/30/2001. How do I get the most recent year?

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  July 31, 2002 at 5:45 pm

  #433744

  max should give you the max date. Are these character values?

  you can do max(datepart(year, value))

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

• finney1969

  SSC Veteran

  Points: 227

  More actions

  July 31, 2002 at 7:33 pm

  #433767

  Thanks, that gives me the year but I also require the month and day...

• GRN

  Hall of Fame

  Points: 3260

  More actions

  August 1, 2002 at 12:36 am

  #433774

  you seem to be storing the dates as character values . use MAX(CONVERT(Datetime,value))