topic date format in Application Development and Automation Discussions

date format

Former Member — Fri, 16 Nov 2007 23:17:14 GMT

Hi guys,

i am working on one report in which i am getting date from the selection screen.

i defined

parameters: p_datum like sy-datum.

i am getting it in the format YYYYMMDD.

now i want to convert it to MMDDYYYY.

the problem is i am looking for any function module which will convert date from YYYYMMDD to MMDDYYYY.

i tried CONVERT_DATE_TO_INTERNAL and CONVERT_DATE_TO_external .

but nothing is working for MMDDYYYY formt .

the second problem is i am using this program for different country and all have different format of date so i want one way which will convert date for any country.

Thanks,

Jack

Re: date format

Former Member — Fri, 16 Nov 2007 23:22:06 GMT

Hi Jack,

do like this

date = sy-datum.

Concatenate date4(2) date6(2) date+0(4) into new_date.

Reward if this helps,

Satish

Re: date format

naimesh_patel — Fri, 16 Nov 2007 23:53:32 GMT

You can do it also..

data: l_char(8) type c.

write: l_date to l_char  MMDDYYYY.

Regards,

Naimesh Patel

Re: date format

Former Member — Sat, 17 Nov 2007 03:10:04 GMT

Hi,

try this,

parameters: p_datum like sy-datum.

write : p_datum MMDDYYYY.

For more date formats look at this link,

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/write_op.htm

Re: date format

Former Member — Sat, 17 Nov 2007 03:57:10 GMT

Hi JACK,

Why it is not working ?... it should work ...

try to pass accurate parameters in FMs...

use below Function modules to solve ur problem...

CONVERT_DATE_TO_EXTERNAL

CONVERSION_EXIT_PDATE_OUTPUT



data: lv_date type sydatum,
e_calc_date type sydatum.

lv_date = sy-datum.
lv_year = lv_date(4).
lv_month = lv_date+4(2).
lv_day = lv_date+6(2).

concatenate lv_month lv_day lv_year into E_CALC_DATE.

Hope it will solve ur problem..

Reward points if useful

Thanks & Regards

ilesh 24x7

Re: date format

Former Member — Sat, 17 Nov 2007 04:42:07 GMT

PDOT_DATE_CONVERT