Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ALSM_EXCEL_TO_INTERNAL_TABLE date format issue

Hi,

I am using function module ALSM_EXCEL_TO_INTERNAL_TABLE,  cells with format  DD/MM/YYYY are uploaded  changing the order of months and Days.

(EX. 12/01/1986 become 01/12/1986)


More strange thing: it does this only if  'day' is less than 12... If I write a date that have days more than 12 it take the date in right format.

(Ex. if I write 13/01/1986 come exact 13/01/1986)...

I tried to change the format of the cell in Excel file but it doesen't cause any effect...

Internal table exporting by the function doesen't have any date format declared for the field that stored the value from excel cells, I can't undestand where and why it do this convertion....

Any help will be appreciated.

Thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question