simple date problem

[#1]

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

[#2 · Accepted solution]

got it with this

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