topic Re: Converting date format in Application Development and Automation Discussions

Converting date format

Former Member — Fri, 04 Jul 2008 07:40:08 GMT

Hi folks,

Pls tell me the function module which converts date format from 20080704 to 04.07.2008. I have done it by offet operations. But i want to do it by FM. pls help me..

Thanks.

Shyam.

Re: Converting date format

Former Member — Fri, 04 Jul 2008 07:42:57 GMT

Use this FM CONVERT_DATE_TO_INTERN_FORMAT

Reward if helpful.

Regards

Chandralekha.

Re: Converting date format

Former Member — Fri, 04 Jul 2008 07:43:25 GMT

Hi,

Use the function module

'CONVERT_DATE_TO_INTERN_FORMAT'

Hope it is usefull...

Jaya Vani

Re: Converting date format

Former Member — Fri, 04 Jul 2008 07:44:25 GMT

Hi,

If you are looking for printing the date based on user format

WRITE sy-datum TO date_short would help,

or else you can try

WRITE sy-datum TO date_long,

date_mask DD/MM/YY.

Re: Converting date format

Former Member — Fri, 04 Jul 2008 07:45:08 GMT

Check out FM's

CONVERT_DATE_TO_INTERNAL or CONVERT_DATE_TO_EXTERNAL.

Regards,

Santosh

Re: Converting date format

Former Member — Fri, 04 Jul 2008 07:45:10 GMT

U don't need any fm but only WRITE statament:

WRITE <DATE IN> TO <DATE OUT> .

Max

Re: Converting date format

Former Member — Fri, 04 Jul 2008 07:46:59 GMT

you can also ues this CONVERT_DATE_INPUT

Reward if helpful.

Regards

Chandralekha.

Re: Converting date format

Former Member — Fri, 04 Jul 2008 07:55:06 GMT

hi jusu try this,

data: dt(8) type c,

dt = sy-datum

dt will contain 04.07.2008

Re: Converting date format

vinod_vemuru2 — Fri, 04 Jul 2008 08:30:15 GMT

Hi Syam,

I assume ur date is like this 2008-year, 07-month 04-date.

If u always want ur date in DD.MM.YYYY then use concatenate statement.

DATA: w_date TYPE sy-datum VALUE '20080704',

w_date1(10) TYPE c.

CONCATENATE w_date6(2) w_date4(2) w_date+0(4) INTO w_date1 SEPARATED BY '.'.

If u want the date as per user settings then even no need of FM. U can simply use WRITE TO statement.

WRITE w_date TO w_date1.

This will write the date as per user settings.

eg: If user setting is MM-DD-YYYY.

Then above statement will write 07-04-2008 to w_date1.

Check SU3 transaction=>Defaults tab for user settings. U can try above thing by changing ur settings.

Note: Settings will be effective from next log on onwards.

Thanks,

Vinod.

Re: Converting date format

former_member787646 — Fri, 04 Jul 2008 12:11:52 GMT

Hi,

Try the FM "CONVERT_DATE_TO_EXTERNAL" and check.

Hope it helps you.

Murthy.