topic Re: Date format in excel attachment in Application Development and Automation Discussions

Date format in excel attachment

Former Member — Wed, 11 Apr 2012 08:11:10 GMT

Hi All,

I am using CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1' to send excel attachment to mail.

I am filling DATE column of excel attachment as below:

DATA l_date TYPE string.

CONSTANTS: lc_apostrof(4) TYPE c VALUE ''''.

DATA ls_date TYPE datum.

CONCATENATE lc_apostrof ls_date INTO l_date.

But in my excel sheet it is downloaded as 'yyyymmdd, while I was expecting yyyymmdd.

Colud you help me where I went wrong.

Regards,

Dep

Re: Date format in excel attachment

rajeevgoswami1 — Wed, 11 Apr 2012 09:23:13 GMT

hi deep ,

you wote like ' my excel sheet it is downloaded as 'yyyymmdd, while I was expecting yyyymmdd ' , so I could not get your question properly in which format you want the date .

What i know that

if you assign date using '= ' operator and concatnate ,

then format will be 'yyyymmdd'.

ex.

ls_date = sy-datum.

if you use 'write to' and concatnate

then format will be 'MMDDYYYY'.

ex.

write sy-datum to ls_date.

I think you already know this.

If this not soving the issue please let me know.

Regards ,

Rajeev