topic Re: date in Application Development and Automation Discussions

date

Former Member — Tue, 24 Oct 2006 15:01:23 GMT

hi experts,

i got the dates in the internal table, how can i caluculate first oldest date and second oldest date.

Thanks and regards,

praveen

Re: date

Former Member — Tue, 24 Oct 2006 15:02:16 GMT

SORT table DESCENDING by date.

Re: date

FredericGirod — Tue, 24 Oct 2006 15:02:58 GMT

sort ...

just because SAP store the date with year first, month second ... you can sort the date to have the first and the second ..

Fred

Re: date

Former Member — Tue, 24 Oct 2006 15:03:31 GMT

sort itab by date descending.

read table itab index 1.

itab-date is the oldest.

read table itab index 2.

itab-date is the 2nd oldest.

Re: date

Former Member — Tue, 24 Oct 2006 15:03:32 GMT

Hi praveen,

sort the internal table by the date up or down.

than you can loop and gets the result.

Regards, Dieter

Re: date

RichHeilman — Tue, 24 Oct 2006 15:04:13 GMT

Hi, first sort your internal table by the date in descending order.

sort itab by datum descending.

Then simply read the first two lines to get the dates.

read table itab index 1.
if sy-subrc  = 0.
Write:/ 'This is the first oldest date', itab-datum'.
endif.

read table itab index 2.
if sy-subrc  = 0.
Write:/ 'This is the second oldest date', itab-datum'.
endif.

Regards,

Rich Heilman

Re: date

Former Member — Tue, 24 Oct 2006 15:04:43 GMT

Hi,

Sort the table in descending order .

Cheers

Re: date

Former Member — Tue, 24 Oct 2006 15:05:29 GMT

Hi,

You can use

SORT ITAB BY DATE DESCENDING.

READ TABLE ITAB INDEX 1. "To get the first oldest date.

READ TABLE ITAB INDEX 2. "To get the second oldest date.

Thanks,

Naren

Re: date

Former Member — Tue, 24 Oct 2006 15:20:53 GMT

Am I missing something? Shouldn't it be <b>ascending</b>?

Rob

Re: date

messier31 — Tue, 24 Oct 2006 20:09:00 GMT

Hi Praveen

Rob is right..

It should be Asscending

since descending will give latest dates and not the oldest dates

Just take care while coding...

Re: date

RichHeilman — Tue, 24 Oct 2006 20:38:35 GMT

Right, its all in how you view the question, does oldest mean farthest away from current, or the most current.

Regards,

Rich Heilman

Re: date

Former Member — Tue, 24 Oct 2006 21:04:53 GMT

So if management asked you to archive the oldest documents you would ask if they meant "farthest away from current, or the most current"?

Rob

Re: date

RichHeilman — Tue, 24 Oct 2006 21:22:53 GMT

In that case, I would say farthest. Your point is very clear, Rob.

Regards,

Rich Heilman