Discussion board where members can get started with QlikView.
I have this date value as above and column is called ExpDate and I want to convert this to Month and Year.
year(ExpDate ) for Year
Month(ExpDate ) For Month.
Both doesnt work
May be this:
Month(ExpDate) as Month,
Year(ExpDate) as Year;
LOAD Date#(ExpDate, 'DD-MMM-YY') as ExpDate