Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "today" in an XLS Query
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "today" in an XLS Query
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 JTurner wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "today" in an XLS Query
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. "Dennis" wrote: 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 JTurner wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "today" in an XLS Query
I believe that you may need to use the function Syntax of MS Query not
the syntax of Excel. Dennis JTurner wrote: 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. "Dennis" wrote: 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 JTurner wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
changing query source | Excel Worksheet Functions | |||
enable automatic refresh | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) |