topic Re: Comparing dates in one internal table in Application Development and Automation Discussions

Comparing dates in one internal table

Wil_Wilstroth — Thu, 06 Jul 2006 03:05:52 GMT

Hi guys,

I have an internal table with 3 fields. One of the fields is holding date.

I need to compare these dates in the internal table to find the latest.

Do you know any function module that can compare dates to find the latest in one internal table?

Thanks

William Wilstroth

Re: Comparing dates in one internal table

Former Member — Thu, 06 Jul 2006 03:09:27 GMT

Why don't simply SORT the internal table by DATE DESCENDING and take the first row.

SORT ITAB BY DATE_COLUMN DESCENDING.

READ TABLE ITAB INDEX 1

Regards,

Ravi

Re: Comparing dates in one internal table

Former Member — Thu, 06 Jul 2006 03:19:44 GMT

Sort the table using below command

sort i_table by date_field decending.

read i_table index 1.

Re: Comparing dates in one internal table

Former Member — Thu, 06 Jul 2006 03:29:26 GMT

Hi William,

U can use this sample of code to get the latest among the three dates of an internal table.

DATA : BEGIN OF itab OCCURS 0,

date1 TYPE sy-datum,

date2 TYPE sy-datum,

date3 TYPE sy-datum,

END OF itab.

DATA : l_date TYPE sy-datum.

itab-date1 = '20061228'.

itab-date2 = '20061201'.

itab-date3 = '20061231'.

APPEND itab.

itab-date1 = '20060728'.

itab-date2 = '20060601'.

itab-date3 = '20060531'.

APPEND itab.

LOOP AT itab.

IF itab-date1 >= itab-date2.

IF itab-date1 >= itab-date3.

l_date = itab-date1.

ELSE.

l_date = itab-date3.

ENDIF.

ELSEIF itab-date2 >= itab-date3.

l_date = itab-date2.

ELSE.

l_date = itab-date3.

ENDIF.

WRITE : / l_date, sy-tabix.

ENDLOOP.

Hope it will help u in some way.

Re: Comparing dates in one internal table

Former Member — Thu, 06 Jul 2006 05:06:50 GMT

GOOD

I DONT THINK THERE IS ANY DATE FUNCTION MODULE WHO WILL COMPARE DATE IN A INTERNAL TABLE AND GIVE YOU THE RESULT.

TRY WITH

RH_GET_DATE_DAYNAME return the day based on the date provied

THANKS

MRUTYUN

Re: Comparing dates in one internal table

Former Member — Thu, 06 Jul 2006 05:29:54 GMT

hi william,

u can use TIMESTAMP functionality for sort ur internal table , it sort bye date as well as timealso .

i hope it will help u.

with regard

chetan vishnoi