Skip to Content
0
Former Member
Mar 12, 2007 at 09:44 AM

to find the latest date and latest time

317 Views

hi all

I have a ZTABLE which contains fields as NAME, DATE ,TIME and STATUS. Entries are

Eg: ztest 01.01.2005 12:05:10 1

ztest 12.01.2005 15:05:10 1

ztest1 23.01.2005 12:05:10 1

ztest1 05.04.2005 05:05:10 1

ztest1 15.10.2005 05:05:10 1

ztest1 15.10.2005 15:05:10 1

Now I need to fetch the latest data and latest time. So I need ztest1 15.10.2005 15:05:10 1.

How can we retrieve it. Even If i use SORT ZTABLE BY DATE TIME DESCENDING I am not getting the lastest date and latest time

Kinldy help

Points will be rewarded

Thanksin advance