topic Re: date format problem in excel format in Application Development and Automation Discussions

date format problem in excel format

Former Member — Thu, 16 Aug 2007 06:02:15 GMT

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

Re: date format problem in excel format

rajesh_akarte2 — Thu, 16 Aug 2007 06:32:57 GMT

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

Re: date format problem in excel format

Former Member — Thu, 16 Aug 2007 07:00:44 GMT

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.

Re: date format problem in excel format

Former Member — Thu, 16 Aug 2007 07:04:24 GMT

declare Date fields as

data: date(10) type C.

Regards

Peram