topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Wed, 03 Jan 2007 06:21:31 GMT

Hi All,

Is there any function module to convert a date as shown in example.

example:

13/01/2007 (dd/mm/yyyy) as 13 January 2007 or 13 Jan 2007.

Thank you

Jaison

Former Member — Wed, 03 Jan 2007 06:24:42 GMT

no there is no such FM..u have to do it via logic with the help of table

t247 .

Demo code -

data : d1(8) value '20051215',

c1(2),

c2(10).

c1 = d1+3(2).

select ktx into x_ktx from T247 where spras = 'E'.

concatenate d16(2) x_ktx d10(4) into c2.

write c2.

Former Member — Wed, 03 Jan 2007 06:25:04 GMT

Hi Jaison,

Check the thread,

Regards,

Hema.

Former Member — Wed, 03 Jan 2007 06:26:20 GMT

Hi ,

The FM is CONVERSION_EXIT_IDATE_OUTPUT.

You need to pass the date in the format YYYYMMDD

Regards

Arun

Message was edited by:

Arun R

Former Member — Wed, 03 Jan 2007 06:40:13 GMT

Dear Jaison,

(1) Extract the first 2 characters from the Date String in dd/mm/yyyy format.

(2) Use "MONTH_NAMES_GET" Function Module to get hold of the Month Name.

(3) Extract the last 4 characters from the Date String in dd/mm/yyyy format.

(4) Concatenate (1) (2) and (3) into a variable and display it.

Regards,

Abir

************************************