topic FM module for convert date format in Application Development and Automation Discussions

FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:14:44 GMT

Hi ,

Is there any function module for convert date format month dd, yyyy

to yyyymmdd.

Ex : Jan 30,2008 to 20080130.

Points will be awarded .

Thanks in advance,

Satya

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:22:31 GMT

hi ,

use fm 'PERIOD_AND_DATE_CONVERT_OUTPUT'

reward if helpfull.

Reagards,

Dhan

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:23:04 GMT

Hi,

U can try this code:

if you have a variable lv_date in mmddyyyy formatthen use

Concatenate lv_date+4(4)

lv_date+0(2)

lv_date+2(2)

into lv_date.

Hope it helps you.

Reward points if helpful.

Regards,

Mukul

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:23:20 GMT

CONVERT_DATE_TO_EXTERNAL.

CONVERT_DATE_TO_INTERNAL.

DATE_STRING_CONVERT

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:24:13 GMT

Satya,

Try function module CONVERT_DATE_INPUT.

Regards,

Kiran Bobbala

Re: FM module for convert date format

kiran_k8 — Fri, 06 Jun 2008 10:26:54 GMT

Hi,

1.CONVERSION_EXIT_SDATE_OUTPUT

changes the date format as 31 Aug 2007 if given as 31/08/2007.

2.DATE_CONV_EXT_TO_INT

User formatted date is converted to system date.

Check the system date format.

K.Kiran.

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:27:06 GMT

Hi,

Try this FM CONVERT_DATE_TO_INTERN_FORMAT

Reward if usefull,

Thanks,

Ramya.R

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:29:25 GMT

Hi,

first convert the month from string to number.

i think there is no function module.

once u convert to 01302008 then use convert_date_to_internal to change to yyyymmdd.

Edited by: Poonam Naik on Jun 6, 2008 12:31 PM

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:30:08 GMT

CONCATENATE field+4(4) field(4) INTO l_date_internal.

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:30:42 GMT

hi use this,

parameters:p_date type d.

data: v_date1 type d.

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

DATE_EXTERNAL = p_date

IMPORTING

DATE_INTERNAL = v_date1.

write:/ v_date1.

reward points if useful,

Re: FM module for convert date format

Former Member — Fri, 06 Jun 2008 10:34:02 GMT

Satya,

there is no FM for this specific requirement.

you just code using split and concatenate.

Amit.