Where is my error?

[#1]

Hi! I'm new using QV. I have to show the field "FECHA DESDE" in three columns (Day, Month and Year). I wrote this script

LOAD [FECHA DESDE],
DAY (FECHA DESDE)
MONTH (FECHA DESDE),
YEAR (FECHA DESDE),
FROM [PERSONAL\comision desde.xls] (biff, embedded labels, table is [PersonalCOMP$]);

But i have an error like this: error in expresion: ')' expected

How can i do to fix this?

Thanks!!

[biester · Accepted solution]

1. Use the square brackets also in the day, month and year functions, e.g.:

DAY([FECHA DESDE]) ....

2. after the DAY(..) in your post ther is no comma .. of course ther must be one

Perhaps this helps.

Rgds,
Joachim

[#3]

Try this

LOAD [FECHA DESDE],
DAY ([FECHA DESDE])
MONTH ([FECHA DESDE]),
YEAR ([FECHA DESDE]),
FROM [PERSONAL\comision desde.xls] (biff, embedded labels, table is [PersonalCOMP$]);

Talha

[#4]

Thanks Joachim and Talha but when i tried that i have a sintax error like this:

Sintax Error. Clause FROM displaced or Clause FROM didnt find. (excuse me for my english!)

[biester]

Remove the comma behind the YEAR() ...(just before the FROM).

Rgds,
Joachim

[prieper]

... and add one comma after DAY([FECHA DESDE])

Peter

[biester]

... as I suggested in my first reply.

[#8]

THANKS FOR ALL. I CAN DO IT .... this is de correct script:

directory;
Load
DAY ([FECHA DESDE]) as [DAY DESDE],
MONTH ([FECHA DESDE]) as [MONTH DESDE],
YEAR ([FECHA DESDE]) as [YEAR DESDE]
FROM (biff, embedded labels, table is [PersonalCOMP$]);

THANKS!