Uploading an excel file in Web Dynpro for ABAP

I am uploading an excel file in Web Dynpro for ABAP and it comes in number format instead of date. How this can be resolved?

0 0

1 Answer

SAP Expert

Answered on 5th Dec, 2017

Note that an Excel stores data in number format and to display in date format, you have to show it format as a date.

You can also try using this formula: TEXT(31421,"YYYY-mm-dd") and the date should display correctly.

0 0