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?
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.