Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

year function not working

Hi All,

kindly assist. 

the year and month functions are not returning a value.

2 Replies
sunny_talwar

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

Capture.PNG

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

Not applicable
Author

Thank you.  this worked:).