10-13-2008 1:01 PM
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
10-13-2008 1:10 PM
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
10-13-2008 1:04 PM
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.
10-13-2008 1:04 PM
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
10-13-2008 1:06 PM
Hi ,
Try this FM
'CONVERSION_EXIT_LDATE_OUTPUT' u2013 Converts date format
Regards,
Sachin M M
10-13-2008 1:10 PM
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