year function not working

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

kindly assist.

the year and month functions are not returning a value.

Re: year function not working

sunny_talwar — Sun, 19 Mar 2017 16:08:41 GMT

Your date field is not read as date field by QlikView... you can change the date format in the environmental variables

Or you can fix it using Date#() function

Date(Date#(invoice_date, 'M/D/YYYY')) as [Invoice Date],

Year(Date#(invoice_date, 'M/D/YYYY')) as Year,

Month(Date#(invoice_date, 'M/D/YYYY')) as Month,

Read about dates here:

Tue, 21 Mar 2017 16:44:24 GMT

Thank you. this worked:).