Date in words format in script Eg : 21st April, 2009

[Former Member]

Hi All,

I need to display the date in the following format.

If the date is 21 April 2009, it should be 21st April 2009.

If the date is 11 April 2009, it should be 11th April 2009.

Please let me know how can i achieve this.

Thanks & Regards,

Sunanda.

[Former Member]

Hi

Regards,

Sravanthi

[Former Member]

Hi,

parameter: d1 TYPE char10 default '10.10.2008'.

data: d2 TYPE char20.

SELECT SINGLE ltx FROM t247

INTO d2

WHERE spras = 'EN'

AND mnr = d1+3(2).

CASE d1(2).

WHEN '01'.

CONCATENATE d2 d1(2) INTO d2 SEPARATED BY space.

CONCATENATE d2 'st' INTO d2.

WHEN '02'.

CONCATENATE d2 d1(2) INTO d2 SEPARATED BY space.

CONCATENATE d2 'nd' INTO d2.

WHEN '03'.

CONCATENATE d2 d1(2) INTO d2 SEPARATED BY space.

CONCATENATE d2 'rd' INTO d2.

WHEN OTHERS.

CONCATENATE d2 d1(2) INTO d2 SEPARATED BY space.

CONCATENATE d2 'th' INTO d2.

ENDCASE.

CONCATENATE d2 d1+6(4) INTO d2 SEPARATED BY ', '.

Regards,

Shiva Kumar

[Former Member]

HI,

You can try writing the logic to get the suffix for the day..

refer to this link..

[Former Member]

data : lv_n(2) type n.

lv_n = date+0(2).

if lv_n = '01'.

1st

elseif lv_n = '02'

2nd

elseif lv_n = '03'

3rd

elseif lv_n = '04'

4th

elseif lv_n = '05'

5th

.....