Discussion board where members can get started with Qlik Sense.
I have date field with below records. Please help me to derive year field from below date field.
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 YearTo format as date: DATE(DATE#(RIGHT(Date,4),'YYYY'),'YYYY') AS DateYear
View solution in original post