error while uploading Cost center data

[former_member549415]

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

[MarcinPciak]

>

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

M.

[former_member549415]

hi Marcin ,

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

Regards

Somnath

[Former Member]

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@

[Former Member]

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.

[Former Member]

Hi

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

Regards,

Vishwa.