Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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
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
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!)
Remove the comma behind the YEAR() ...(just before the FROM).
Rgds,
Joachim
... and add one comma after DAY([FECHA DESDE])
Peter
... as I suggested in my first reply.
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
THANKS!