Date Format

[Former Member]

Dear All

In my input the date format is '20.08.1013' i have to convert it into '13.10.2008'.

Can any one help me to solve this problem.,

Thanks,

Thirukumaran. R

[GauthamV]

hi,

open any transaction and in menu goto system - user profile - own data ,there click on defaults tab and give date format as DD.MM.YYYY.

[Former Member]

Hi,

Create a Z-Function Module for this:

Using it you can Convert the date according to User format, or in any other format.

FUNCTION Z_SETDATE_TO_USER_PROFILE.

*"----

---

""Local interface:

*" IMPORTING

*" VALUE(IN_DATE) LIKE SY-DATUM

*" EXPORTING

*" VALUE(OUT_DATE) LIKE KLAHD-CREAT_DATX

*" EXCEPTIONS

*" INVALID_INPUT_DATE_FORMAT

*"----

---

TABLES: USR01.

DATA: DATE_FORMAT LIKE USR01-DATFM,

MONTH(2) TYPE C,

DAY(2) TYPE C,

YEAR(4) TYPE C.

• VALIDATE THE INPUT DATE

CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'

EXPORTING

DATE = IN_DATE

EXCEPTIONS

PLAUSIBILITY_CHECK_FAILED = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

• ERROR MESSAGE

ENDIF.

• GET THE DATE INTO IT'S MONTH, DAY AND YEAR COMPONENTS

MONTH = IN_DATE+4(2).

DAY = IN_DATE+6(2).

YEAR = IN_DATE(4).

• IN THE USER PROFILE TABLE DETERMINE THE DATE FORMAT

SELECT SINGLE DATFM

INTO DATE_FORMAT

FROM USR01

WHERE BNAME = SY-UNAME.

• ACCORDING TO THE USER PROFILE FORMAT THE INPUT DATE

CASE DATE_FORMAT.

WHEN '1'.

CONCATENATE DAY '.' MONTH '.' YEAR INTO OUT_DATE.

WHEN '2'.

CONCATENATE MONTH '/' DAY '/' YEAR INTO OUT_DATE.

WHEN '3'.

CONCATENATE MONTH '-' DAY '-' YEAR INTO OUT_DATE.

WHEN '4'.

CONCATENATE YEAR '.' MONTH '.' DAY INTO OUT_DATE.

WHEN '5'.

CONCATENATE YEAR '/' MONTH '/' DAY INTO OUT_DATE.

ENDCASE.

ENDFUNCTION.

Regards,

Swati

[sachin_mathapati]

Hi ,

Try this FM

'CONVERSION_EXIT_LDATE_OUTPUT' u2013 Converts date format

Regards,

Sachin M M

[Former Member]

Hi,

Use the function module FORMAT_DATE_4_OUTPUT

DATA : DATE TYPE CHAR10.

CALL FUNCTION 'FORMAT_DATE_4_OUTPUT'
  EXPORTING
    DATIN         = '20081013'
    FORMAT        = 'DD.MM.YYYY'
 IMPORTING
   DATEX         = DATE
          .

WRITE : / DATE.

Regards

Edited by: Rajvansh Ravi on Oct 13, 2008 2:21 PM