date format problem in excel format

[Former Member]

Hi,

I am uploading the date field from excel to program.

My problem is in date format.

I am gettting the date format in ddmmyyyy if it is 01012006 then my excel sheet contains the date as 1012006 i.e '0' initial zero is truncated in the excel sheet .

Now how can i use this date in my program i.e i have to convert into date as per program requirements like dd.mm.yyyy .How can i convert.

Thanks and regards,

shyla

[Former Member]

Hi,

I am uploading the date field from excel to program.

My problem is in date format.

I am gettting the date format in ddmmyyyy if it is 01012006 then my excel sheet contains the date as 1012006 i.e '0' initial zero is truncated in the excel sheet .

Now how can i use this date in my program i.e i have to convert into date as per program requirements like dd.mm.yyyy .How can i convert.

Thanks and regards,

shyla

[rajesh_akarte2]

Hi shyla,

To eliminate the problem u r facing u can change the format of the date column in excel sheet as 'Text'.Then the '0' appearing at first won't be truncated...

Please reward the point if useful............

Regards,

Rajesh

[Former Member]

Hi Shyla,

if the provided excel sheet contains date in format "20122006" the field is considered as a number format.

In this case you can do the following select the whole column and go to format/cells. Choose the "custom" category on the Number tab and

enter zeros in eight digits, i.e. 00000000 under "Type:".

This should solve your problem before uploading the data into SAP.

[Former Member]

declare Date fields as

data: date(10) type C.

Regards

Peram