Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

simple date problem

got it with this

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

1 Reply
Not applicable

simple date problem

got it with this

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