topic Re: Function Module for Date Conversion in Application Development and Automation Discussions

Function Module for Date Conversion

Former Member — Wed, 29 Aug 2007 05:16:46 GMT

I need a Fnction Module which converts the date which is in the format 20020918(YYYYMMDD)

to 18.09.2002 (DD.MM.YYYY)

Pls suggest me one.

Thanks in advance.

Re: Function Module for Date Conversion

Former Member — Wed, 29 Aug 2007 05:19:16 GMT

Hi john

Please try to use

FM : HRGPBS_HER_FORMAT_DATE

Best Regards

Wiboon

Re: Function Module for Date Conversion

gopi_narendra — Wed, 29 Aug 2007 05:22:33 GMT

You can do it this way.

date10(2) = date6(2).

date12(2) = date4(2).

date14(4) = date0(4).

date1 is in DDMMYYYY format

date is in YYYYMMDD format

OR

You can use this FM : CONVERSION_EXIT_PDATE_OUTPUT

Regards

Gopi

Re: Function Module for Date Conversion

Former Member — Wed, 29 Aug 2007 05:23:00 GMT

Use FM CONVERT_DATE_TO_INTERN_FORMAT .

Pass DTYPE as 'DATS'.

Please reward points if useful.

Regards,

Taranam

Re: Function Module for Date Conversion

varma_narayana — Wed, 29 Aug 2007 05:24:20 GMT

Call the FM CONVERT_DATE_TO_EXTERNAL..

this will convert from internal format (YYYYMMDD) TO external format as per the user profile.

You can also check the FMs CONVERSION_EXIT_LDATE_OUTPUT

CONVERSION_EXIT_SDATE_OUTPUT

CONVERSION_EXIT_PDATE_OUTPUT

reward if Helpful

Re: Function Module for Date Conversion

Former Member — Wed, 29 Aug 2007 05:27:19 GMT

FM: CONVERSION_EXIT_PDATE_OUTPUT

Re: Function Module for Date Conversion

Former Member — Wed, 29 Aug 2007 05:27:34 GMT

Hello,

You can also do ABAP coding to get successful result

Please check the code below as an alternative solution

DATA : L_TEMP TYPE SY-DATUM.

eg : L_BUDAT contains date in the format 20020918

L_TEMP0(2) = L_BUDAT6(2). "passed date

L_TEMP2(2) = L_BUDAT4(2). "passed Month

L_TEMP4(4) = L_BUDAT0(4). "passed year

L_BUDAT = L_TEMP.

Now L_BUDAT contains date as 18092002

CLEAR L_TEMP.

You can go to SE#&

Put DATECONV* -> press F4 and -> lots of function modules related to date conversion will pop up...Pls see the description if any suits your need

Reward if helpful

Regards

Byju

Re: Function Module for Date Conversion

Former Member — Wed, 29 Aug 2007 05:27:57 GMT

Hi,

If you want always the date formate dd.mm.yyyy then while moving the date value use like below

concatenate date6(2) '.' date4(2) '.' date+0(4) into date1.

or if you want the user setting format then use the write statement.

Regards,

Satya.

Re: Function Module for Date Conversion

Former Member — Wed, 29 Aug 2007 05:27:58 GMT

Use FM CONVERT_DATE_TO_INTERN_FORMAT .

and fill appropriate parameters