topic compare two dates in Application Development and Automation Discussions

compare two dates

Former Member — Tue, 22 Apr 2008 23:04:54 GMT

hi gurus,

i have an internal table with 10 records.

one of the columns is 'Modification Date' ,

i need to get the latest of the records, ie. the date which is most recent.

how do i acomplish this task,

is there a function module to compare dates in an internal table.

thanks.

former_member156446 — Tue, 22 Apr 2008 23:07:32 GMT

you can use sort based on date and as well as compare as well

sort table itab1 by dat1 descending.

sort table itab2 by dat2 descending.

if itab1-dat1 > itab2-dat2.

....

former_member254848 — Tue, 22 Apr 2008 23:07:34 GMT

Sort the internal table by date descending and pick the first record.

Former Member — Wed, 23 Apr 2008 04:43:10 GMT

Hello Sanjana-

To get the latest record comparing date field for ex:budat.

sort i_tab by budat ascending.

read table i_tab into w_area index 1.

Cheers,