topic Re: Regarding Date Formating in Application Development and Automation Discussions

Regarding Date Formating

Former Member — Fri, 02 Sep 2005 10:03:38 GMT

Hi All,

I have a issue regarding Date formatting.

At present i am getting date in SAP format to my internal table field. Format is [YYYYMMDD] ex: 20050902.

I want to make that field in following format as : DD-MMM-YYYY ex: 02-SEP-2005.

can any body solve my issue.

Thanks in advance.

Thanks & Regards,

Rayeezuddin.

Re: Regarding Date Formating

FredericGirod — Fri, 02 Sep 2005 10:07:07 GMT

Please read the SAP Documentation by pressing F1 on the key word WRITE.

(in an Unix world, the answer will be RTFM)

Re: Regarding Date Formating

Vinod_Chandran — Fri, 02 Sep 2005 10:10:46 GMT

Use the function module as given below.

data: w_date(10).

call function 'CONVERT_DATE_TO_EXTERNAL'

exporting

date_internal = <- Field in YYYYMMDD format

importing

date_external = w_date

exceptions

date_internal_is_invalid = 1

others = 2.

Message was edited by: Vinod C

Re: Regarding Date Formating

Former Member — Fri, 02 Sep 2005 10:12:13 GMT

Hi,

I had tried with that option but did not worked.

Any other solution without using any function module.

Thanks & Regards,

Rayeez.

Re: Regarding Date Formating

Former Member — Fri, 02 Sep 2005 10:19:42 GMT

Hi vinod,

I want YYYYMMDD format field to be displayed in DD-MMM-YYYY format.

Above FM what u have given is not suited for exact requirement can u give a solution where by we can directly translate YYYYMMDD format field into DD-MMM-YYYY format.

Thanks for ur time.

Thanks & Regards,

Rayeez.

Re: Regarding Date Formating

Former Member — Fri, 02 Sep 2005 10:37:25 GMT

Using Function modules

************************

data: gd_date(8).

"field to store output date

Converts date from 20010901 to 01SEP2001

gd_date = sy-datum.

CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'

EXPORTING

input = gd_date

IMPORTING

OUTPUT = gd_date.

Refer this link

http://www.sapdevelopment.co.uk/tips/date/date_format.htm

Kindly reward points and close the thread.

Praff

Re: Regarding Date Formating

Former Member — Fri, 02 Sep 2005 10:39:52 GMT

can you hardcode it with concatenate then it can be solved.

con.....' ' '-'' '-' into .........

regards

Re: Regarding Date Formating

Vinod_Chandran — Fri, 02 Sep 2005 10:40:19 GMT

Hi,

Can you try CONVERSION_EXIT_IDATE_OUTPUT?

Another way is to get the month name using 'MONTH_NAMES_GET and concatenate date and year with it.

Thanks

Vinod

Re: Regarding Date Formating

Former Member — Fri, 02 Sep 2005 10:51:58 GMT

Hi,

The FM 'CONVERSION_EXIT_IDATE_OUTPUT' giving ouput as SEP012001 instead of 01SEP2001 when giving input as 20010901.

Do we need to make any changes to get it as 01SEP2001.

Thanks & Regards,

Rayeez.

Re: Regarding Date Formating

Former Member — Fri, 02 Sep 2005 10:57:10 GMT

Hi,

This the code

REPORT ztest2.

data: mydate type d,

mychar(11).

data C_T247 type T247 occurs 0 with header line.

mydate = sy-datum.

call function 'MONTH_NAMES_GET'

TABLES

MONTH_NAMES = C_T247

EXCEPTIONS

others = 9.

READ TABLE C_T247 WITH KEY MNR = mydate+4(2).

concatenate mydate6(2) C_T247-KTX mydate0(4) into mychar

separated by '-'.

write mychar.

Output: 02-SEP-2005

Svetlin

P.S. If you find an answer helpful, please assign reward points.

Message was edited by: Svetlin Rusev