topic Is there any function module to convert the date format in Application Development and Automation Discussions

Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:36:31 GMT

Dear ABAPers,

Is there any function module to convert the date format from dd.mm.yyyy to dd-mmm-yyyy.

I want to convert the date format from dd.mm.yyy to dd.mmm.yyy Eg.from 10.03.2008 to 10-mar-2009.

Thanks & Regards,

Ashok.

Re: Is there any function module to convert the date format

former_member242255 — Tue, 10 Mar 2009 04:38:24 GMT

FM HR_IN_GET_DATE_COMPONENTS

Edited by: Sravan Kumar on Mar 10, 2009 5:41 AM

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:39:10 GMT

you can check IDATE,SDATE,LDATE Conversion Function module. Always search before posting.

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:39:34 GMT

hi,

Refe to this link..[How to change date format from DD.MM.YYYY to DD-MMM-YYYY|]

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:40:52 GMT

Hi,

As per my knowledge no FM like. But you can use Replace statement where '.' find you can replace '-'. Finally you can get requirement.

Regards

Md.MahaboobKhan

Re: Is there any function module to convert the date format

I355602 — Tue, 10 Mar 2009 04:43:31 GMT

Hi,

Please use FM : CONVERT_DATE_TO_INTERN_FORMAT

to convert date in to internal format.

Regards,

Tarun

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:44:51 GMT

hi friend look my following example.

To format date fields, use the SAPscript SET DATE MASK command. Executing this command causes all subsequent date fields to be printed with the specified formatting.

Syntax

/: SET DATE MASK = 'date_mask'

The following templates may be used in the date mask:

DD day (two digits)

DDD name of day (abbreviated)

DDDD name of day (written out in full)

MM month (two digits)

MMM name of month (abbreviated)

MMMM name of month (written out in full)

YY year (two digits)

YYYY year (four digits)

LD day (formatted as for the L option)

LM month (formatted as for the L option)

LY year (formatted as for the L option)

Any other characters occurring in the mask are interpreted as simple text and are copied directly to the output.

Assuming a current system date of March 1st, 1997.

/: SET DATE MASK = 'Foster City, MM.DD.YY'

&DATE& -> Foster City, 03.01.97

&DATE(Z)& -> Foster City, 3.1.97

/: SET DATE MASK = 'MMMM DD, YYYY'

&DATE& -> March 01, 1997

You can revert to the standard setting by using the SET DATE MASK command again with an empty string in place of the date mask:

/: SET DATE MASK = ' '

Re: Is there any function module to convert the date format

keerthy_k — Tue, 10 Mar 2009 04:48:41 GMT

Hi,

The FM CONVERSION_EXIT_SDATE_OUTPUT will convert the date format 20090310 to 10.MAR.2009.

or the FM CONVERSION_EXIT_IDATE_OUTPUT

Keerthi

Edited by: Keerthy K on Mar 10, 2009 5:50 AM

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:49:36 GMT

Hi,

try this...




data: ws_input type sy-datum,
ws_date type char20.

ws_input = '20080321'.

CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'
EXPORTING
input = ws_input
IMPORTING
OUTPUT = ws_date
.

Replace All Occurences of '.' IN ws_date with '-'.

write ws_date.

Thanks

Arun

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:51:16 GMT

Hi Ashok,

Try the following piece of code

data d1 type d .

data d2(20).

d1 = sy-datum.

write sy-datum.

CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'

EXPORTING

INPUT = d1

IMPORTING

OUTPUT = d2.

replace all occurrences of '.' in d2 with '-'.

write / d2.

This would give you the desired output.

Regards,

Sachin

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:55:26 GMT

Hi,

Try with the following function modules these may help you

CONVERSION_EXIT_IDATE_OUTPUT External date OUTPUT conversion exit (e.g. 01JAN1994)

CONVERSION_EXIT_LDATE_OUTPUT Internal date OUTPUT conversion exit (e.g. YYYYMMDD)

CONVERSION_EXIT_SDATE_OUTPUT Internal date OUTPUT conversion exit (e.g. YYYYMMDD)

Thank U,

Jay....

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 04:56:11 GMT

Hi,

go through the piece of code .....i hope u will get some help

DATA X_MONTH(11).

CALL FUNCTION 'CONVERSION_EXIT_LDATE_OUTPUT'

EXPORTING

INPUT = SY-DATUM

IMPORTING

OUTPUT = X_MONTH.

WRITE:/ 'Month in words', X_MONTH+3(8).

you can then concatenate according to the need with the date..

thanks & Regards

Ashu Singh

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 05:02:16 GMT

Hi ,

U can use FM /SAPDMC/LSM_DATE_CONVERT

to convert into both internal and External Date formats.

Just need to give correct "date_format_in"

Thanks

Raj

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 05:14:44 GMT

Hi,

You can try using this function module:



CONVERSION_EXIT_IDATE_OUTPUT

Hope it helps

Regrds

Mansi

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 05:48:55 GMT

You can create your own fumction module for this

Input the date in character 10 format and output the date also in character 10 format.

Following sample code will help you complete the logic

Data :

Date_in(10) TYPE C,

Date_out(10) type c,

To_mmm(3) type c,

l_separator,

l_dd(2),

l_mm(2),

l_yyyy(4).

*Check the date in and find the separator

CONDENSE DATE_IN NO-GAPS.

IF DATE_IN CN '0123456789 '.

L_SEPARATOR = DATE_IN+SY-FDPOS(1).

ENDIF.

get date,month and year separated from the date_in

IF NOT L_SEPARATOR IS INITIAL.

SPLIT DATE_IN AT L_SEPARATOR INTO L_DD L_MM L_YYYY.

*convert the month number to text

*complete all month cases as shown for JAN

Case l_mm.

when '1'.

to_mmm = 'JAN'.

when '2'.

when '3'.

when '4'.

when '5'.

when '6'.

when '7'.

when '8'.

when '9'.

when '10'.

when '11'.

when '12'.

endcase.

*build the output date

Perform build_date using l_dd to_mmm l_yyyy '-'

CHANGING DATE_OUT.

FORM BUILD_DATE USING P_1

P_2

P_3

P_SEPARATOR

CHANGING P_RESULT.

CONCATENATE P_1 P_SEPARATOR

P_2 P_SEPARATOR

P_3 INTO P_RESULT.

ENDFORM. " BUILD_DATE

Re: Is there any function module to convert the date format

sarbajitm — Tue, 10 Mar 2009 06:40:37 GMT

REPORT ZSAR_DATE_FORMAT. TABLES: T247. DATA : dd(2) TYPE c, mm(2) TYPE c, mon(3) TYPE c, yy(4) TYPE c, new_date(11) TYPE c. PARAMETERS: Date(10) TYPE C. SPLIT Date AT '-' INTO dd mm yy. SELECT SINGLE ktx FROM T247 INTO mon WHERE spras = sy-langu AND mnr = mm. CONCATENATE dd '-' mon '-' yy INTO new_date. WRITE: / new_date.

please run the above program to get your desired format.

Thanks.

Re: Is there any function module to convert the date format

sarbajitm — Tue, 10 Mar 2009 11:27:00 GMT

Hi Ashok!!

Are you still watching the thread? have not got your desired answer/output? If you get it, please mark the thread as ANSWERED.

Thanks and Regards.

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 11:28:58 GMT


> Hi Ashok!!
> Are you still watching the thread? have not got your desired answer/output? If you get it, please mark the thread as ANSWERED.
> 
> Thanks and Regards.

Aren't you......??

Re: Is there any function module to convert the date format

Former Member — Tue, 10 Mar 2009 11:38:48 GMT

hi,

create custom function module or copy the below code in the report ..and use it

the out put for below is :----Convert a DATE field into a full format date eg. March 23, 2000

FUNCTION Z_CONVERT_DATE_INTO_FULL_DATE.

*"----

""Local interface:

*" IMPORTING

*" VALUE(DATE) LIKE SY-DATUM

*" EXPORTING

*" VALUE(FORMATTED_DATE)

*" EXCEPTIONS

*" INVALID_DATE

*"----

TABLES: TTDTG.

DATA: BEGIN OF T_DATE,

YYYY(4) TYPE C,

MM(2) TYPE C,

DD(2) TYPE C,

END OF T_DATE.

DATA: DAY(3) TYPE N.

DATA: VARNAME LIKE TTDTG-VARNAME.

IF DATE IS INITIAL.

CLEAR FORMATTED_DATE.

EXIT.

ENDIF.

check document date format

CALL FUNCTION 'DATE_CHECK_PLAUSIBILITY'

EXPORTING

DATE = DATE

EXCEPTIONS

PLAUSIBILITY_CHECK_FAILED = 1.

IF SY-SUBRC NE 0.

RAISE INVALID_DATE.

ENDIF.

MOVE DATE TO T_DATE.

CONCATENATE '%%SAPSCRIPT_MMM_' T_DATE-MM INTO VARNAME.

SELECT SINGLE * FROM TTDTG WHERE SPRAS = 'EN' AND VARNAME = VARNAME.

WRITE T_DATE-DD TO DAY.

CONCATENATE DAY ',' INTO DAY.

CONCATENATE TTDTG-VARVALUE DAY T_DATE-YYYY INTO FORMATTED_DATE

SEPARATED BY SPACE.

ENDFUNCTION.

the output is :--Convert a DATE field into a full format date eg. March 23, 2000

Regards,

Prabhudas

Re: Is there any function module to convert the date format

sarbajitm — Tue, 17 Mar 2009 12:57:20 GMT

Hi Ashok!!

Are you still watching the thread? have not got your desired answer/output? If you get it, please mark the thread as ANSWERED.

Thanks and Regards.