Date conversion

UN
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

Answers

Setup Info
    Tags
      Help me…