Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Date to Month and Year


I have this date value as above and column is called ExpDate and I want to convert this to Month and Year.

I tried

year(ExpDate ) for Year

Month(ExpDate ) For Month.

Both doesnt work

Thank you.

1 Reply

Re: Date to Month and Year

May be this:


          Month(ExpDate) as Month,

          Year(ExpDate) as Year;

LOAD Date#(ExpDate, 'DD-MMM-YY') as ExpDate

FROM Source