how do i select month for a date.
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
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
Retrieving data ...