10-27-2007 3:02 PM
Experts,
I want to convert the date like August 25th, 2007.
my requirement is 'th' should be suffix to the '25'.
thanks.
vijay
10-27-2007 3:48 PM
Hi VijayKumar,
REPORT zkb_test3.
PARAMETERS: p_date TYPE sy-datum.
DATA: v_date TYPE string.
CASE p_date+4(2).
WHEN 01.
CONCATENATE 'January' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 02.
CONCATENATE 'Febuary' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 03.
CONCATENATE 'March' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 04.
CONCATENATE 'April' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 05.
CONCATENATE 'May' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 06.
CONCATENATE 'June' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 07.
CONCATENATE 'July' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 08.
CONCATENATE 'August' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 09.
CONCATENATE 'September' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 10.
CONCATENATE 'October' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 11.
CONCATENATE 'November' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 12.
CONCATENATE 'December' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
ENDCASE.
WRITE:/ v_date.
<b>Reward points if it is useful..</b>
Cheers
ilesh 24x7
10-27-2007 3:48 PM
Hi VijayKumar,
REPORT zkb_test3.
PARAMETERS: p_date TYPE sy-datum.
DATA: v_date TYPE string.
CASE p_date+4(2).
WHEN 01.
CONCATENATE 'January' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 02.
CONCATENATE 'Febuary' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 03.
CONCATENATE 'March' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 04.
CONCATENATE 'April' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 05.
CONCATENATE 'May' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 06.
CONCATENATE 'June' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 07.
CONCATENATE 'July' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 08.
CONCATENATE 'August' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 09.
CONCATENATE 'September' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 10.
CONCATENATE 'October' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 11.
CONCATENATE 'November' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
WHEN 12.
CONCATENATE 'December' p_date+6(2) 'th,' p_date(4)
INTO v_date SEPARATED BY space.
ENDCASE.
WRITE:/ v_date.
<b>Reward points if it is useful..</b>
Cheers
ilesh 24x7