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

simple date problem

I have the InvoiceDate in the format of MM/DD/YYYY and

in my script


SET DateFormat='DD.MM.YYYY';
SALES:
LOAD [Actual Delivery Date],
CustKey as [Customer Number],
DateKey,
[Discount Amount],
[Invoice Date],
Year(date#([Invoice Date],'MM.DD.YYYY')) as Year,
Month(date#([Invoice Date],'MM.DD.YYYY')) as Month,
[Invoice Number],
.........


why I dont get the year and Month here I dont understand?

Help is appreciated.

Thanks

Sravan

1 Solution

Accepted Solutions
Not applicable
Author

got it with this

Year(date#([Invoice Date],'MM/DD/YYYY')) as Year,
Month(date#([Invoice Date],'MM/DD/YYYY')) as Month,

View solution in original post

1 Reply
Not applicable
Author

got it with this

Year(date#([Invoice Date],'MM/DD/YYYY')) as Year,
Month(date#([Invoice Date],'MM/DD/YYYY')) as Month,