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.