Using "today" in an XLS Query

G

Guest

I am trying to run a query of all employees in our database with a
termination date greater than today or is null. The null part is working
fine, but it appears that query doesn't recognize "today()", "date()",
"now()" or any of the other million ways I've tried. Can Query use today's
date in criteria? If so, how? I would prefer not to have to enter the date
using parameter. Thanks!
 
D

Dennis

Is it possible that your question relates to Access and not Excel?

The reference to "database" and query cause me to lean towards Access.
If so please try the MS Access forum.

Dennis
 
G

Guest

Nope...not through Access. I'm querying an Oracle database using Excel via
"Data", "Import External Data", "New Database Query". From there, I use MS
Query to view and edit the criteria.
 
D

Dennis

I believe that you may need to use the function Syntax of MS Query not
the syntax of Excel.

Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the =TODAY() option 3
Date search query 0
Today's Date in MS Query 3
Query Parameters 1
Microsoft Query criteria syntax for date() or today() 4
Return records entered today 14
Criteria using "Or" and parameter query 2
Parameter query conversion error on date 1

Top