Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
To get the number: RIGHT(Date,4) AS Year
To format as date: DATE(DATE#(RIGHT(Date,4),'YYYY'),'YYYY') AS DateYear
To get the number: RIGHT(Date,4) AS Year
To format as date: DATE(DATE#(RIGHT(Date,4),'YYYY'),'YYYY') AS DateYear