Date conversion

Solved!
UN
Level 2
Date conversion

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! 

 

 

0 Kudos
1 Solution
MiguelangelC
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.

 

 

 

View solution in original post

0 Kudos
3 Replies
MiguelangelC
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.

 

 

 

0 Kudos
UN
Level 2
Author

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

Hi @UN thank you for accepting the solution! Here are some additional resources you may find helpful if you haven't already accessed them:

I hope this helps!

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as โ€˜Accepted Solutionโ€™ to help others like you!