topic Re: date format problem in Application Development and Automation Discussions

date format problem

Former Member — Fri, 07 Sep 2007 13:31:46 GMT

hi all,

suggest me some function module for date format( from dd.mm.yyyy to yyyymmdd).

when i am passing sy-datum through bdctable to f-53 transaction code screen.

in sy-datum i have dd.mm.yyyy. and when it goes to on screen (in document date,and in posting date field) it change into to yyyymmdd.

In the table(bkpf) that fields stored as yyyymmdd only. i think due to this ,its happen.

how do i sove that problem.

thank you.

Re: date format problem

RichHeilman — Fri, 07 Sep 2007 13:44:07 GMT

Yes, you must covert to external format when using the date in BDC. So do this.



data: bdc_date(10) type c.

call function 'CONVERT_DATE_TO_EXTERNAL'
     exporting
          date_internal = sy-datum
     importing
          date_external = bdc_date.

Now pass the BDC_DATE field to the BDC PERFORM statement.

Regards,

Rich Heilman

Re: date format problem

Former Member — Fri, 07 Sep 2007 13:44:12 GMT

concatenate l_docdate8(4) l_docdate4(2) l_docdate+0(2) into l_finaldate.

Re: date format problem

Former Member — Fri, 07 Sep 2007 13:47:07 GMT

hi pavan,

u can convert the date format use EDIT MASK in write statement and then use that variable.

hope this will be usefull...

Regards,

prashant

Message was edited by:

Alvaro Tejada Galindo

Re: date format problem

Former Member — Fri, 07 Sep 2007 13:53:06 GMT

good

data : v_date like sy-datum.

write : v_date using edit mask '__/__/____'

call function 'CONVERT_DATE_TO_INTERNAL'

thanks

mrutyun^

Re: date format problem

Pawan_Kesari — Fri, 07 Sep 2007 13:53:13 GMT

While passing the date to BDC you cannot hardcode it.. you should take care of the user format..

simply use WRITE statement to format the date in user format..

data lv_date type char10 .

WRITE sy-datum to lv_date

then pass lv_date to BDC