4 Replies Latest reply: Sep 13, 2012 6:41 AM by melaniehuggins RSS

    Load error

      Can anyone tell me why the

      Year(Transactiondate) as Year,

      Month (Transactiondate) as Month

       

      is not working in the load statement below. Something similar has worked for me in other QV files but not this one

      Transactiondate is in this format dd/mm/yyyy in excel

       

      Thanks

       

      LOAD

       

      [Invoice centre],
      [Cost centre],
      [Driver name],
      [Card number],
      [Gross amount],
      [Net amount],
      [Unit price],
      [VAT amount],
      Quantity,
      [Product Charge description],
      Transactiondate,
      Year (Transactiondate) as Year,
      Month (Transactondate) as Month,
      [Supplier invoice number],

      [Brand name]

       

       

        • Re: Load error
          Kamal Naithani

          Can you share the application here.I think that may be some syntax error.Can you be more specific that what the error message is coming when you are loading .

           

           

           

           

          Regards

          Kamal Naithani

            • Re: Load error

              this is the error.

              How do I attach a file???

               

              Field not found - <Transacton date>

              LOAD [Invoice centre],

                   [Cost centre],

                   [Card number],

                   [Gross amount],

                   [Net amount],

                   [Unit price],

                   [VAT amount],

                   Quantity,

                   [Product Charge description],

                   [Transaction date],

              Year ([Transaction date]) as Year,

              Month ([Transacton date]) as Month,

                   [Supplier invoice number],

                   [Brand name]

            • Re: Load error
              Kamal Naithani

              Hi Friend,

              Month (Transactondate) as Month,....This is the error as You are having
              [Transaction date] as Field

              But when you are using Month ([Transacton date]) as Month, you have made the spelling mistake.

               

               

               

              Hope it helps

               

               

              Regards

              Kamal