Load error

[#1]

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]

[kamalqlik]

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

[#3]

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]

[kamalqlik · Accepted solution]

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

[#5]

Thanks, sometimes you can't see the wood for the trees. All working now