Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
kindly assist.
the year and month functions are not returning a value.
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:
Thank you. this worked:).