topic Re: BDC UPDATED in Application Development and Automation Discussions

BDC UPDATED

Former Member — Thu, 07 Jun 2007 07:25:54 GMT

HI,

WHILE UPDATED OR MODIFYING RECORD IN CASE OF BACK GROUND SCHEDULLING WE GET ERROR I MEAN FOR DATE ANY PROCESS TO OVER COME (INVALID DATE)

FLAT FILE DATA IS DDMMYYYY THIS NOT TAKING .UPDATION AND MODI IS NOT HAPPENNING

amit_khare — Thu, 07 Jun 2007 07:30:04 GMT

While writing BDC for that just convert date to internal format before assigning it to BDC table.

Since different users may have different date formats so its a better practice to conver date to internal formats.

Same is true for Quantity & currency fields also.

Regards,

Amit

Reward all helpful replies.

Former Member — Thu, 07 Jun 2007 07:32:08 GMT

Hi,

you need to convert the date to the User format, lets say your date field is DATE1,

then create the second field DATE2.

Date: DATE2(10) type c.

Write: DATE1 to DATE2.

so here the DATE2 will have the User format, so use this DATE2 field in your program

Regards

Sudheer