GETTING LATEST DATE

[Former Member]

Hi,

I want to collect the latest date from a table containing a number of dates.

how do i achieve dis???

[Former Member]

Hi,

Sort the date in descending order and then read the first table entry.

Hope this helps.

Regards,

Richa

[Former Member]

Hi,

<b>For internal table..</b>

SORT ITAB BY DATE DESCENDING.

• get the latest date

READ TABLE ITAB INTO WA INDEX 1.

<b>For database table</b>

SELECT MAX( DATE) INTO V_DATE FROM ztable WHERE ..

Thanks,

Naren

[gopi_narendra]

sort it_tab by <date> descending.

read it_tab index 1.

Regards

Gopi

[Former Member]

SORT itab BY date DESCENDING.

Now your first record will have latest date.

Reward points if useful.

Regards,

Atish

[sreeramkumar_madisetty]

Hi

Sort the date in descending order and then read the first table entry

Regards,

Sree

Message was edited by:

sree ram

[Former Member]

DATA : BEGIN OF ITAB OCCURS 0,

VDATE LIKE SY-DATUM,

END OF ITAB.

SELECT MAX( <DATE FIELD> ) INTO TABLE ITAB FROM DBTAB WHERE <CONDITION>.

LOOP AT ITAB.

WRITE : ITAB-VDATE.

ENDLOOP.

REGARDS

SHIBA DUTTA

[Former Member]

Hi

Can you be little more clear with your requirement?

with respect to which module or which table you are asking this?

Regards

Anji

[Former Member]

Hi,

try this..

select max( date ) into v_date from ztable.

select max( time ) into v_time from ztable.

[Former Member]

Hi,

U can get the latest date by sorting ur internal table with key as date descending.

{Also if u coding in HR abap,

use <b>rp_provide_from_last p0001 space pn-begda pn-endda</b>

This wil help u to fetch the latest records for the entered begin date and end date.}

Hope this helps.

****Rewars points if helpful.

All the best