Date conversion

UN

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!

Miguel Angel

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.

UN

Thanks much! It worked! I didn't know the "mm" in "yyyyMM" has to be in block letters. This is very helpful.

CoreyS

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!