topic Changing the date Format in Application Development and Automation Discussions

Changing the date Format

shilpik20 — Tue, 06 Mar 2007 02:57:06 GMT

I have managed to copy the system date to a field using the sy-datlo. Now i want to change the date format to 'MM/DD/YYYY'. Please Help.

Former Member — Tue, 06 Mar 2007 03:03:33 GMT

Hi,

use the Function module CONVERT_DATE_TO_EXTERNAL

example:

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

DATE_INTERNAL = VLDAT

IMPORTING

DATE_EXTERNAL = DATE

EXCEPTIONS

DATE_INTERNAL_IS_INVALID = 1

OTHERS = 2

IF SY-SUBRC <> 0.

ENDIF.

regards,

keerthi

Message was edited by:

keerthi kiran varanasi

amit_khare — Tue, 06 Mar 2007 03:03:41 GMT

welcome to SDN.

Concatenate sy-datum4(2) '/' sy-datum6(2) '/' sy-datum+0(4) into v_date.

Regards,

Amit

Reward all helpful replies.

Former Member — Tue, 06 Mar 2007 03:06:20 GMT

Hi,

Welcome to SDN.

You can use offset.


data: wa_date(10).

concatenate sy-datlo+4(2) '/' sy-datlo+6(2) '/' sy-datlo(4) into wa_date.

write: /wa_date.

Regards,

Ferry Lianto

Former Member — Tue, 06 Mar 2007 05:32:18 GMT

Hi,

you have option called edit-mask go for that statement you will get the date format what ever you want.

hope it will help u.