SO_NEW_DOCUMENT_ATT_SEND_API1 convert date

[Former Member]

Hello!

We use FM SO_NEW_DOCUMENT_ATT_SEND_API to create a 'CSV' file and send it with email, but there is a Problem with the date. After creating the csv file the date 201606100757 (yyyymmddHHMM) is converted to 2,01606E+11.

In this file we need the format (yymmddHHMM).

If a TXT file is created with this FM, the date is ok.

Dose anyone know a solution?

Best regards,

Manuel

[Former Member]

Hello!

We use FM SO_NEW_DOCUMENT_ATT_SEND_API to create a 'CSV' file and send it with email, but there is a Problem with the date. After creating the csv file the date 201606100757 (yyyymmddHHMM) is converted to 2,01606E+11.

In this file we need the format (yymmddHHMM).

If a TXT file is created with this FM, the date is ok.

Dose anyone know a solution?

Best regards,

Manuel

[Former Member]

Hi Manuel,

Did you try to expand the column and see the content in the CSV File.

Could you please attach the screen shot of the column here.

Thanks and Regards,

Vinay Mutt

[Former Member]

Assuming its already char type, Add ' (single quote before passing the value -> equals to '''').

CONCATENATE ''''

                          v_date

                          INTO v_date.

[Former Member]

Hi, thanks for your quick Response!

@Vinary Mutt

I tried that and it's still in the wrong Format.

@Elzkie La

Now the value of the column is '201606100757. The date is correct, but now i have a single Quote at first.

[Former Member]

internally it will be displayed with quote but in csv it will not be visible. It's defaulted in excel/csv with 2,##+11 number. Not sure if there is any other solutions for this for excel formating from sap.

[Former Member]

Hi

Did you try with declaring data type as NUMC instead CHAR.

Rgds,

Guna