Skip to Content
0
Former Member
Dec 09, 2008 at 10:42 AM

Sorting With date and time

40 Views

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