Extract Year from Date

[mahitham]

Hi ,

I have date field with below records. Please help me to derive year field from below date field.

Date

CMM 01 May 2020

CCM 02 Apr 2019

CCM 05 Aug 2020

CCM 10 April 2020

Thanks in advance

[Ivan_Bozov · Accepted solution]

To get the number: RIGHT(Date,4) AS Year
To format as date: DATE(DATE#(RIGHT(Date,4),'YYYY'),'YYYY') AS DateYear