topic Re: error while uploading Cost center data in Application Development and Automation Discussions

error while uploading Cost center data

former_member549415 — Fri, 07 Nov 2008 12:08:06 GMT

hi to all

I m doing with BDC uploading the Cost center from Excel file

but while updateing it showing the error invalid Date

but in Excel file Date format is 01.04.2008,

while uploading data in KS01 it taking 20080401 like this format

,if i will give it in 01.04.2008 format its working properly please guide me

Thanks in Advanced

Re: error while uploading Cost center data

MarcinPciak — Fri, 07 Nov 2008 12:19:03 GMT


> while uploading data in KS01 it taking 20080401 like this format 
> ,if i will give it in 01.04.2008 format its working properly please guide me

Date in format 01.04.2008 is only a user-specific date ouput, which means how it is displayed to you, not how you enter it.

In the excel file change your date format to 01042008 and retry. Should work.

Re: error while uploading Cost center data

Former Member — Fri, 07 Nov 2008 12:19:32 GMT

hi,

try this.

concatenate x6(2) '.' x4(2) '.' x+0(4) into ur date field.

directly u cont pass the value. u have to split and concatenate like date format then execute. it will work.

Re: error while uploading Cost center data

Former Member — Fri, 07 Nov 2008 12:22:04 GMT

Convert the date into internal format using Function Module CONVERT_DATE_TO_INTERNAL...and then pass it to the screen field.

Regards,

Vishwa.

Re: error while uploading Cost center data

former_member549415 — Sat, 08 Nov 2008 06:09:40 GMT

hi Marcin ,

Even i tried this ,means i removed '.' like this 01042008 but it didnt worked

Regards

Somnath

Re: error while uploading Cost center data

Former Member — Sat, 08 Nov 2008 07:14:38 GMT

Hi,

Format your excel sheet and restrict the column width to 8.

How to do this keep the cursor on the column number (or) name and right click by which you can see column width there you restrict the width to 8 because date field allows 8 characters but internally it formats the date accordingly.

Cheers!!

VEnk@