Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Date to Month and Year

30-Jul-18

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
Highlighted

Re: Date to Month and Year

May be this:

LOAD *,

          Month(ExpDate) as Month,

          Year(ExpDate) as Year;

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

FROM Source