topic Re: Regarding Date in Application Development and Automation Discussions

Regarding Date

Former Member — Thu, 28 Aug 2008 12:16:27 GMT

hi all,

How can we find maximum date among given dates.

Please suggest.

Regards

Reddy

Re: Regarding Date

JozsefSzikszai — Thu, 28 Aug 2008 12:17:52 GMT

hi,

depends on the data source: for example if the dates are in an internal table, than you can sort the internal table by date descending and the date in the first line will be the highest.

hope this helps

Re: Regarding Date

naveen_inuganti2 — Thu, 28 Aug 2008 12:18:30 GMT

Hi....

You can easily trace this by using IF conditon with GT ( > ) sign.

---naveen.I

Re: Regarding Date

Former Member — Thu, 28 Aug 2008 12:19:48 GMT

Hi,

put the date in an internal table, sort table DESCENDING, and read the first entry.

Regards, Dieter

Re: Regarding Date

Former Member — Thu, 28 Aug 2008 12:19:55 GMT

sort by descending order

read table with index 1.

Re: Regarding Date

Former Member — Thu, 28 Aug 2008 12:20:35 GMT

hi ram redddy .,

if it is from DB table USe MAX(DATE) .

if it is from internal table just Sort table by date descending .

read table itab with key index = 1 .

thanks

Sreenivas Reddy

Re: Regarding Date

Former Member — Thu, 28 Aug 2008 12:20:57 GMT

Hi ramireddy,

If your data is in internal table then sort that internal table descending by date. Now you can easily get the maximun date.

Regards,

Rajitha.

Re: Regarding Date

naveen_inuganti2 — Thu, 28 Aug 2008 12:30:15 GMT

Hi.....

Check this code...

Do like this if those dates in variables...

or half this code.... if those dates in internal tables....

data: date1 like sy-datum,
      date2 like sy-datum,
      date3 like sy-datum,
      date4 like sy-datum,
      date5 like sy-datum.

date1 = sy-datum.
date2 = sy-datum - 1.
date3 = sy-datum - 4.
date4 = sy-datum + 10.
date5 = sy-datum + 1.

data: begin of itab occurs 0,
      date like sy-datum,
      end of itab.

itab-date = date1.
append itab.
clear itab.
itab-date = date2.
append itab.
clear itab.
itab-date = date3.
append itab.
clear itab.
itab-date = date4.
append itab.
clear itab.
itab-date = date5.
append itab.
clear itab.

sort itab descending.             <----start from here if your dates in internal tables.

read table itab index 1.

if sy-subrc = 0.
  write:/ itab-date.
endif.

Thanks,

Naveen.I