topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Wed, 29 Nov 2006 11:03:32 GMT

Hi all,

Is there any Function module to convert date from one format to other?

eg : convert date from DDMMYYYY to YYYYWWD.

Thanking You,

Kasinath Babu.

Re: date conversion

Former Member — Wed, 29 Nov 2006 11:05:15 GMT

Please don't post duplicate posts for the same issue.

Did you see the blog I have referred to?

Regards,

Ravi

NOte - Please close this post and continue with the other one.

Re: date conversion

Former Member — Wed, 29 Nov 2006 11:05:16 GMT

This question has already been answered in your other thread . Please close this question and the other one also.

Re: date conversion

Former Member — Wed, 29 Nov 2006 11:05:20 GMT

YOu can just use the write statement:

write sy-datum to lv_datum edit mask 'YYYYMMDD'.

reGARDS,

rAVI

Re: date conversion

Former Member — Wed, 29 Nov 2006 11:31:37 GMT

Hi all,

I want the conversion from the format ( date month year ) to (year week day of week ) i.e. YYYY WW D

Re: date conversion

Former Member — Wed, 29 Nov 2006 11:37:48 GMT

HI,

Date = YYYYMMDD

Concatenate date4(2) ‘ /’ date6(2) ‘/’ date(4) into Date2.

data : l_date(10) type c .

concatenate sy-datum6(2) '/' sy-datum4(2) '/' sy-datum(4) into l_date.

write : l_date.

data :l_date(10) type c

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

DATE_INTERNAL = SY-DATUM

IMPORTING

DATE_EXTERNAL = l_date.

PARAMETERS: P_DATE LIKE SY-DATUM.

DATA: T_MONTHS LIKE STANDARD TABLE OF T247 WITH HEADER LINE.

DATA: DATE LIKE AUSP-ATWRT.

CALL FUNCTION 'MONTH_NAMES_GET'

TABLES

MONTH_NAMES = T_MONTHS.

READ TABLE T_MONTHS WITH KEY MNR = P_DATE+4(2).

DATE(2) = P_DATE+6(2).

DATE+2(3) = T_MONTHS-KTX.

DATE5(2) = P_DATE2(2).

WRITE DATE.

Regards,

Laxmi.