1 Reply Latest reply: Nov 4, 2009 7:29 PM by Sravan Puppala RSS

    simple date problem

    Sravan Puppala

      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