date conversion problem

[Former Member]

scenario: idoc to JDBC

i think i will be getting data in mm/dd/yyyy from idoc. but the DB needs data dd/mm/yy.

so i mapped as below:

source fld --> transformation date API --> target field.

Source in date transformation: MM/dd/yyyy

Target : dd/MM/yyyy

am trying to test with 28/12/2007 and my output is 12/04/2009

y is it wrong?

do i have to make any more changes?

thanks,

kiran

[Former Member · Accepted solution]

Hi,

28/12/2007 is not compliant with MM/dd/yyyy! You would receive an error, because 28 is not a valid month. You need to change to 12/28/2007, or change the input mask to dd/MM/yyyy.

regards.

roberti

Edited by: Waldemar Roberti on Dec 28, 2007 10:19 AM

[Former Member · Accepted solution]

am sorry.

i have given it as 12/12/2007 only. now it worked fine for it.

Thanks for ur finding. it was a silly mistake.

[Former Member]

Hi kiran,

use the date function in graphical mapping.

Thats it

Regards Mario