topic Re: Date Conversion ? in Application Development and Automation Discussions

Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:28:33 GMT

hi All,

I want to convert date from this format 01/2007 to January 2007. Is there any FM for performing this operation.

regards,

Navneeth.K

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:30:50 GMT

Hi,

u can use FM : <b>'CONVERSION_EXIT_PDATE_INPUT'</b>

<b>plz reward points if helpful or if it solves ur query.</b>

Thanks

Chinmay

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:31:48 GMT

Check this info.

Use function module CONVERT_DATE_TO_EXTERNAL. This will convert the date to the user specific format. So if your user specific format is MMM YYYY, then this is all you need.

Look at the function moduel MONTH_NAMES_GET It returns all the month and names in repective language

Hope this resolves your query.

Reward all the helpful answers.

Regards

Nilesh

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:32:24 GMT

hi Naveen,

  Try this

REPORT ychatest1.

TABLES : t247.

DATA : v_date(7) VALUE '01/2007',
       v_ltx LIKE t247-ltx,
       v_date1(25).

SELECT SINGLE ltx FROM t247 INTO v_ltx WHERE mnr EQ v_date+0(2) AND spras EQ sy-langu.

CONCATENATE v_ltx v_date+3(4) INTO v_date1 SEPARATED BY space.

WRITE : / v_date1.

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:34:51 GMT

hi,

try these fm's

CONVERSION_EXIT_LDATE_OUTPUT,

CONVERSION_EXIT_SDATE_OUTPUT,

CONV_EXIT_LDATE_OUTPUT_LANGU.

Re: Date Conversion ?

PS_1978 — Mon, 30 Apr 2007 08:35:41 GMT

Hi Navneeth,

you can simply make use of offsets...

Example: v_date(7) type c,

v_year(4) type c.

v_year = v_date+3(4).

Regards,

Phani

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:48:06 GMT

Hi navneeth,

1. using some logic and the FM MONTH_NAMES_GET

(for month names in full),

2. we can write some small program for same.

regards,

amit m.

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:49:54 GMT

hi,

chk this.

DATA: DATE_CHAR(20).
DATA: DATE TYPE SY-DATUM.
DATA: MONTH_NAME LIKE T247-LTX.
DATE = SY-DATUM.

SELECT SINGLE LTX FROM T247
INTO MONTH_NAME
WHERE SPRAS = SY-LANGU
AND MNR = SY-DATUM+4(2).

CONCATENATE SY-DATUM+6(2) MONTH_NAME SY-DATUM(4)
INTO DATE_CHAR SEPARATED BY SPACE.

WRITE: / DATE_CHAR.


or use this FM

CACS_DATE_GET_YEAR_MONTH : To get the number of the month
MONTH_NAMES_GET: To get month description

Regards

Reshma

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 08:52:02 GMT

REPORT test.

TABLES : t247.

DATA : v_date(7) VALUE '01/2007',

v_ltx LIKE t247-ltx,

v_date_final(30).

SELECT SINGLE ltx

FROM t247

INTO v_ltx

WHERE mnr EQ v_date+0(2)

AND spras EQ sy-langu.

CONCATENATE v_ltx v_date+3(4) INTO v_date1 SEPARATED BY space.

WRITE : / v_date_final.

Re: Date Conversion ?

Former Member — Mon, 30 Apr 2007 09:01:30 GMT

hi navneeth,

just copy and paste below code.

report zmahi9.

tables : t247.

data : itab like t247 occurs 0 with header line.

data : date like sy-datum,

vdate(15) type c.

parameter : v_date type t247-ltx default '01/2007'.

date = sy-datum+0(4).

select single * from t247

into itab.

concatenate itab-ltx date into vdate separated by space.

write : vdate.

thanks,

maheedhar.t