Date conversion
UN
Registered Posts: 8 ✭✭✭
Hello!
I have a column with date "2021-06-09T00:00:00.000Z" with storage type and meaning both as "date". Could you please show me how I can convert this to YYYYMM format? I tried using the the format date option in prepare recipe but its converting to YYYY00 instead of YYYYMM.
I have attached the date snippet below in PDF format.
Thanks!
Best Answer
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
Hi,
What is the 'Date format' chosen in the 'Format date' processor?
If you put 'yyyyMM' in that cell you should get the desired result.
Answers
-
Thanks much! It worked! I didn't know the "mm" in "yyyyMM" has to be in block letters. This is very helpful.
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
Hi @UN
thank you for accepting the solution! Here are some additional resources you may find helpful if you haven't already accessed them:- Managing dates (documentation)
- Working with Dates (Knowledge Base)
- Concept: Date Handling (Academy/Knowledge Base)
I hope this helps!