Show the max datetime value data.

[sona_sa]

Sr.No	Mode	Department	Date
101	Rel	A	3/15/2012 7:21:03 PM
101	Rel	B	3/15/2012 7:20:32 PM
101	Cust	C	3/15/2012 7:21:24 PM

Need the output only on the base of date column, which the the max date.

i.e  -

101

Cust

C

3/15/2012 7:21:24 PM

Thanks & Regards

Akumar

[#2]

Use setexpression sum({<[Date]={'$(=Max([Date]))'}>}Value)