Date transformation

[Former Member]

Hi All,

I am getting awiered error in date transformation function.

My source date is in the format(MM/dd/yy) and I need the target date in the format (yyyy-MM-dd). I have used the date transformation function available in the graphical mapping.

suppose I give the date as 09/29/06 I expected the target date as 2006-09-29 but my target date I get as output is <b>0006-09-29</b>. Can any one let me know why this happens and how to correct it?

Thanks & Regards,

Jai Shankar.

[Former Member]

Hi,

Here the reason must be SP version you are working on. I could get the correct results as my XI runs on SP16. You can go for UDF if you are familier with Java.

Regards

Suresh

[Former Member]

Hi Jai,

did you set the parameters (doubleclick on it!) in the "dateTrans" correct?

Format source: MM/dd/yy

Format target: yyyy-MM-dd

This works

Regards Mario

[Former Member]

Hi,

Wo could get the correct transformation of Date format as you specified.

I have tried the data type for date field as Date , Is this a problem? Can you check again?

Regards

Suresh

[Former Member]

Hi,

Yes I have checked it again. I am using the type as date in both source and target msg. I am getting only error.

Thanks & Regards,

Jai Shankar.

[Former Member]

hi date in xsd is not in such format. As far as I'm concerned it should be iso. Please change your field to string with pattern.

regards,

wojtek

[Former Member]

Hi Wojtek,

I changed the field to string. Yet same problem. Can it be due to SP. Iam on SP09(XI3.0).

Thanks & Regards,

Jai Shankar.

[Former Member]

i'm on SP16. So probably is due that. But it's strange because below the cover there is java method of these class:

java.util.SimpleDateFormat

Regards,

wojtek

[Former Member]

hi,

in our system it works.

source: MM/dd/yy

target: yyyy-MM-dd

Please make a doble check.

Regards,

wojtek

[MichalKrawczyk]

hi,

try target: dd-MM-yyyy

if you still see the year like 0006 I suggest creating an OSS note as it looks as a bug

Regards,

michal

[Former Member]

Michal,

Same error. Can any one try this in your server and confirm this is a bug?

Thanks & Regards,

Jai Shankar.