Function DateTrans in PI Mapping has error

[Former Member]

Hi,

when I used the function DateTrans in my PI mapping I found out that when I choose yyyyww as target format the result is wrong. For instance when I have 20100322 the result is 201013. I would expect 201012, instead. Up to now I did not find any OSS note to fix it. Does anyone know more about this problem?

Best regards.

Oliver.

[stefan_grube · Accepted solution]

> when I used the function DateTrans in my PI mapping I found out that when I choose yyyyww as target format the result is wrong. For instance when I have 20100322 the result is 201013. I would expect 201012, instead.

DateTrans determines calender weeks for USA. This is different to Germany.

[Former Member · Accepted solution]

Hi,

I found the advanced options of the DateTrans. I set the first day of the week to Monday and the minimum days of the first week to 4. Now it works correct.

Regards.

Oliver.