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?
"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 '-')
View solution in original post
In a prepare recipe, you can use a Parse Date step to convert strings to date in the format you want.
Hi @cb86 and welcome to the Dataiku Community. In addition to @Célian's excellent explanation I believe this thread should help as well: String dates to datetime format
I hope this helps!
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)?