Solved: Re: Date- to select month - Qlik Community

Report Inappropriate Content · ‎2012-11-26

HI,

how do i select month for a date.

example:

date : 30 jan 2012, 4 feb 2012

how do i extract only jan and feb and turn the data into 01 for jan, and 02 for feb

tq

Anonymous · ‎2012-11-26

You can use the Month() function to extract the month from a proper date.

If it's not working, it means that your dates are not properly recognized as dates and you need to define for QlikView the format. For example:

Month(Date#(DATEFIELD, 'DD MMM YYYY')) as Month

Anonymous · ‎2012-11-26

You can use the Month() function to extract the month from a proper date.

If it's not working, it means that your dates are not properly recognized as dates and you need to define for QlikView the format. For example:

Month(Date#(DATEFIELD, 'DD MMM YYYY')) as Month