How to Check the date and get the latest date?

Hi Everyone,

I've an internal table which holding few records which contain date field. How I can check this internal table by getting the record which contain "latest date" only? Kindly advise. Thank you.

eg:

I should only get the record which contain lastest date. (eg: I should picked up Record3)

Table i_test

Field 1 Field 2(date)

Record1 20090322

Record2 20090101

Record3 20090601

Moderator message - Please search before asking and do not ask basic questions - post locked

Edited by: Rob Burbank on Jun 17, 2009 9:21 AM