I have the InvoiceDate in the format of MM/DD/YYYY and
in my script
LOAD [Actual Delivery Date],
CustKey as [Customer Number],
Year(date#([Invoice Date],'MM.DD.YYYY')) as Year,
Month(date#([Invoice Date],'MM.DD.YYYY')) as Month,
why I dont get the year and Month here I dont understand?
Help is appreciated.