Sorting Date by Year

[Former Member]

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]

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]

sort itab by date+6(4).

[Former Member]

hi Vimal,

do this way ...

sort it_table by date+6(4).

Regards,

Santosh