this is the code
SELECT HelpDesk.Apellido, HelpDesk.Nombre, HelpDesk.Numero_de_Incidente,
HelpDesk.Fecha_de_Creacion, HelpDesk.Creado_por, HelpDesk.Assigned_to,
HelpDesk.Tipo_de_Problema, HelpDesk.Elem__Afectado, HelpDesk.Intervención
FROM HelpDesk HelpDesk
WHERE (HelpDesk.Fecha_de_Creacion={ts '2005-11-25 00:00:00'} And
HelpDesk.Fecha_de_Creacion<={ts '2005-11-26 00:00:00'}) AND
(HelpDesk.Estado<'Closed') AND (HelpDesk.Intervención<'Tarea Planificada')
AND (HelpDesk.Edificio<'Planta Chile')
ORDER BY HelpDesk.Apellido

i need to get the day i run the query.

can you help me?
Thanks a lot.

"Ron Coderre" wrote:

Perhaps if you posted a little more of your SQL code and told us what kind of
database (Oracle, MS Access, SQLServer, etc) you're accessing, we'd have a
better chance of helping.

***********
Regards,
Ron


"ivan" wrote:

i've tried but didnt work, i've tried with getday,now,etc

thanks a lot for your help

"Ron Coderre" wrote:

Ivan

Nothing's really wrong. That's just a notice from MS Query that it can't
represent the RunDate field in a table so it can't show you the query
graphically. From that point on, you'll need to edit the query via the SQL
window.

Does that help?

***********
Regards,
Ron


"ivan" wrote:

Thanks ron, but doesnt work, it says that cant show that query graphically

"Ron Coderre" wrote:

Try this in your SQL code:
Date() as RunDate

Does that help?

***********
Regards,
Ron


"ivan" wrote:

im triyn to retrieve data to excel with the microsoft query
can you help me with the function to get the day i run the query?

get day() doesnt work.

a query error appears!