Date - String to YYYYMM

cb86

Hello,

I have a date (YYYYMM) that is being read as a string. How can i convert/parse this date to be read as a date?

Célian

"yyyy-MM" would parse dates with a '-' between the year and the month, for example "2021-01"

To parse "202101" you need to set the format to "yyyyMM" (without the '-')

Célian

Hello,

In a prepare recipe, you can use a Parse Date step to convert strings to date in the format you want.

CoreyS

Hi @cb86
and welcome to the Dataiku Community. In addition to @Célian
's excellent explanation I believe this thread should help as well:

I hope this helps!

cb86

Thank you both for your quick response. I tried to use the prepare recipe to parse the date. However, I am not seeing any results? I am doing it correctly (image attached)?

cb86

Thank you!