simple date problem

Thu, 05 Nov 2009 00:20:42 GMT

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

simple date problem

Thu, 05 Nov 2009 00:29:13 GMT

got it with this

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

topic simple date problem in QlikView

simple date problem

simple date problem