Sorting With date and time

Former Member — Tue, 09 Dec 2008 10:42:49 GMT

Hi,

i'm finding a issue with sorting of both date and time columns in descending order.

i'm having date and time .

i used code :

sort itab by date descending as text.

sort itab by time descending as text.

08-12-2008 11:23:14

08-12-2008 11:23:11

08-12-2008 11:22:10

08-12-2008 11:21:10

09-12-2008 11:23:14

09-12-2008 11:23:11

09-12-2008 11:22:10

09-12-2008 11:21:00

but i'm not getting the same format as i mentioned above. if sorting on time is made ad not date is getting sorted and viceversa.

please suggest possible changes.

thanks,

kat

Re: Sorting With date and time

JozsefSzikszai — Tue, 09 Dec 2008 10:46:38 GMT

you have to do this in one statement:

SORT itab BY date DESCENDING time DESCENDING.