topic Re: date comparsion in Application Development and Automation Discussions

date comparsion

Former Member — Tue, 12 Jul 2005 03:19:31 GMT

Hi,

i have a date field in an internal table. i need to fetch record with most recent date. is there any function module to do that or is there any date comparision operator.

your help would be appreciated.

Thanks,

kranthi

Re: date comparsion

Former Member — Tue, 12 Jul 2005 03:25:48 GMT

Hi Kranthi,

You can sort the internal table by date field. and get the first record's date. That will fetch you the recent date.

Hope it will solve your problem.

Suvan.

Re: date comparsion

jayanthi_jayaraman — Tue, 12 Jul 2005 03:28:50 GMT

Hi,

Try this.

You can use >,<,etc.,

loop at itab into wa.

if sy-tabix = 1 or v < wa-date.

v = wa-date.

endif.

endloop.

write 'Recent', v.

Re: date comparsion

Former Member — Tue, 12 Jul 2005 03:54:47 GMT

Hi Kranthi / Sankar,

Sorting the internal table by the data field and fetching the first record seems to be the best approach.

Regards,

Anand Mandalika.