topic Sorting Date by Year in Application Development and Automation Discussions

Sorting Date by Year

Former Member — Mon, 25 Jun 2007 06:20:06 GMT

Hi.

I have a requirement that i have to sort a date with respect to year.

The date format is as follows DD/MM/YYYY.

Now when i sort on this format i get the date sorted based on date.

But i want to sort the date based on year..

Also the date should be displayed in the same format as DD/MM/YYYY.

athavanraja — Mon, 25 Jun 2007 08:49:36 GMT

have another dummy field where you store the date in YYYYMMDD format and sort by that field (but dont show it on the screen)

Former Member — Mon, 25 Jun 2007 08:51:30 GMT

sort itab by date+6(4).

Former Member — Mon, 25 Jun 2007 08:52:46 GMT

hi Vimal,

do this way ...

sort it_table by date+6(4).

Regards,

Santosh