How to find Max Date

HI you can convert the date and select max like sudipta replied you.
like
SELECT MAX(Convert(varchar,[date],106)) FROM #temp_table

Jignesh Trivedi12y ago

Hi,

Agree with Sudipta Sanyal, using Max function you can find out maximum value of date in the table.

MAX ignores any null values and Max function is also work with varchar and nvarchar type filed.

hope this will help you.

sudipta sanyal12y ago

CREATE TABLE #temp_table (id int identity,name nvarchar(200),[date] datetime,division nvarchar(200),town nvarchar(200))

INSERT into #temp_table VALUES ('jom','07/15/10','Moscow','ok')

INSERT into #temp_table VALUES ('Becom','05/15/14','New','kk')

INSERT into #temp_table VALUES ('jonson','01/15/14','yon','pp')

INSERT into #temp_table VALUES ('jonson','05/19/14','Moscow','ok')

SELECT MAX([date]) FROM #temp_table

DROP TABLE #temp_table