Problem with date format using TEXT_CONVERT_XLS_TO_SAP

[Former Member]

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

[vinod_vemuru2]

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.

[Former Member]

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.