topic Re: Date Format in Application Development and Automation Discussions

Date Format

Former Member — Mon, 13 Oct 2008 12:01:33 GMT

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

Re: Date Format

GauthamV — Mon, 13 Oct 2008 12:04:04 GMT

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.

Re: Date Format

Former Member — Mon, 13 Oct 2008 12:04:28 GMT

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

Re: Date Format

sachin_mathapati — Mon, 13 Oct 2008 12:06:33 GMT

Hi ,

Try this FM

'CONVERSION_EXIT_LDATE_OUTPUT' u2013 Converts date format

Regards,

Sachin M M

Re: Date Format

Former Member — Mon, 13 Oct 2008 12:10:08 GMT

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