year function not working

[#1]

Hi All,

kindly assist. 

the year and month functions are not returning a value.

[sunny_talwar]

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:

Why don’t my dates work?

Get the Dates Right

[#3]

Thank you.  this worked:).