Skip to Content
0
Jun 06, 2018 at 06:50 AM

Date Format in EXCEL upload in ABAP Program

2166 Views

Dear All,

I have an requirement ,to upload the excel sheet data into a report program for updating material master. In excel sheet , I have one column with date values. I want to validate the value entered by user in excel sheet is in DDMMYYYY.

I am trying to do it as below:

SET PROPERTY OF lv_selection 'NumberFormat' = '[$-14409]dd.mm.yyyy;@'.

but it is not working. acn anyone has worked on similar kind of req?

and also i have one more question , if i enter the value in excel cell starting with 0 , zero is going off.

Thanks,

Arpita