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!