mmm-yyy to year

[iliaisyah]

My excel have a date format mmm-yyy but in qlikview i want to make a list box of year n month. is it possible?

[sunny_talwar]

May be this

Month(Date) as Month,

Year(Date) as Year

or

Month(Date#(Date, 'MMM-YYYY')) as Month

Year(Date#(Date, 'MMM-YYYY')) as Year

[PabloTrevisan]

You have to check if qlik is reading this excel data as DATE or STRING, try to use the date function with the mask you have this way:

Month (Date (datefield, 'MMM-YYY')) AS MONTH,

Year (Date (datefield, 'MMM-YYY)) AS YEAR'

OR

DATE (datefield, 'MMM') AS MONTH,

DATE (datefield, 'YYY') AS YEAR

[iliaisyah]

Thank you. i now know to set the date period

[PabloTrevisan]

Please ILI,

mark the correct answer to close de topic.

thanks