Community Conundrum 25:Feature Visualization is now live! Read More

bug parsed date

Level 2
bug parsed date

Hello,
I need your help because I encounter a bug by performing a very simple operation.

In a "prepare" operation when I "parsed date" the month of January 2019 (only this month) is transformed into January 2018. There is no problem in the other months. A video of the problem is attached to this message. Someone could help me in order to fix this?

 

Thanks for your help

0 Kudos
1 Reply
Dataiker
Dataiker

Hi,

You used "YY" as the pattern. "YY" is the ISO week-year, a fairly arcane concept (https://en.wikipedia.org/wiki/ISO_week_date) that can consider the beginning of a year to actually be the end of the previous one.

Please use "yy" instead of "YY"

0 Kudos