Problem with Date Trans function

[former_member203631]

Hi Frnds,

I have a scenario where i need to convert date format from yyyyMMdd to dd.MM.yyyy. so here the problem is when source is getting value as 2010051A then it is converting to 01.05.2010 instead of giving error.

Is there any patch for this Date Trans function to overcome this bug?

To overcome this Iam converting the date format manually, but I want to know whether we can do some thing to Date Trans function to work properly.

Regards,

Chinna

[stefan_grube]

> Is there any patch for this Date Trans function to overcome this bug?

Tested with PI 7.1 EhP1 SP4: works as you described.

So there is obviously no patch available.

[former_member556603]

Dear Shiva,

To overcome this Iam converting the date format manually, but I want to know whether we can do some thing to Date Trans function to work properly.

Yes you can use replaceString before your date trans function:

Please follow the below example:

X: String in which something is to be replaced

Y: Sequence to be replaced in X

Z: Sequence to replace Y

R = Sequence in which each occurrence of Y in X is replaced by Z.

X = "sparring with a purple porpoise"

Y = u201Cpu201D

Z = u201Ctu201D

R = "starring with a turtle tortoise"

Thanks,

Satya Kumar

[Shabarish_Nair]

use a replace function before the datetrans.

replace all A with 0 and then do the datetrans