Skip to Content
Former Member
Sep 10, 2013 at 10:02 AM

convert excel text format date to SAP ABAP format date


Hi All,

I am uploading an excel file(.xlsx) to ALV in webdynpro. I am able to upload data, however the date field is read as text rather than date type.

Hence I am getting 41500 instead of 8/14/2013.

If you type 8/14/2013 in excel cell and right click and format cell and change the format to text type you will see that 8/14/2013 changes to 41500.

How can I convert back 41500 to 8/14/2013 in ABAP?

Do we have any FM available?

Help will be highly appreciated.