topic Problem with date format using TEXT_CONVERT_XLS_TO_SAP in Application Development and Automation Discussions

Problem with date format using TEXT_CONVERT_XLS_TO_SAP

Former Member — Thu, 04 Mar 2010 19:41:56 GMT

I'm using fm TEXT_CONVERT_XLS_TO_SAP to upload an xls file.

I've the following problem the date in the spreadsheet is 01.01.2010 the result in the internal table after using the fm is 01.jan.2010. What must i do to get 01.01.2010 in the internal table?

My setting in sap for the date format is DD.MM.YYYY

Re: Problem with date format using TEXT_CONVERT_XLS_TO_SAP

vinod_vemuru2 — Thu, 04 Mar 2010 20:28:40 GMT

Hi,

What is type and size of your internal table field? Covert your excel column to text field. Now it is of type date i hope.

Best option is, always have the value in excel in YYYYMMDD (SAP standard format) and internal table field as of type sy-datum.

After uploading use WRITE TO statement to a character variable to convert the date as per user settings. Your current logic may not work if the date setting is different.

Thanks,

Vinod.

Re: Problem with date format using TEXT_CONVERT_XLS_TO_SAP

Former Member — Fri, 05 Mar 2010 07:46:03 GMT

I just found the solution. When an xls is uploaded into sap the function module uses the windows settings of your pc.

My short date format in windows were dd.MMM.yyyy. I've changed them to dd.mm.yyyy and now the date is correct in sap.