Skip to Content

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

Excel upload date format is like "41851"

Hello all! I have a problem with excel date in my program. When i upload date, like date format in excel it upload in my web dynpro like 41851 instead 7/31/2014. How can i solve this problem without changing date in excel?

regards,Nikita

Tags:
Former Member
Former Member replied

I found solution:

data:lv_data        type sy-datum,

       lv_startdate  type sy-datum.

lv_startdate = '19000101'."starting date(excel parameter)

lv_data       = lv_startdate + 41851(the date from excel that we need to convert to normal date) - 2.

write lv_data.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question