Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Today's Date in MS Query

How do I query on today's date. I apparently have the wrong syntax because
I'm constantly getting error messages.

In the criteria, I have =Today(). What are the exact characters I should be
putting in the criteria box to get todays date only? I do not want the user
typing in the date every time he refreshes data.

Thanks for the help.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Today's Date in MS Query

To query on today's date in MS Query, follow these steps:
  1. Open MS Query and select the data source you want to query from.
  2. In the Query Wizard, select the table or tables you want to query and add them to the query.
  3. In the Criteria box for the date field you want to filter on, enter the following syntax:
    =DATEVALUE(TODAY())
    This will filter the data to show only records where the date field is equal to or greater than today's date.
  4. Click Next and follow the remaining steps in the Query Wizard to finish creating your query.

Note that the syntax for querying on today's date may vary depending on the data source you are using. If you continue to receive error messages, you may need to consult the documentation for your specific data source or seek assistance from a technical support professional.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Today's Date in MS Query

Hi Paul,
I'm using Excel. I have external data and I'm filtering it with MS Query.

I tried Date() and it didn't work. Thanks!

"Paul B" wrote:

Lambi000, this is an Excel newsgroup not Access, but try this and see if it
will work Date()
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Lambi000" wrote in message
...
How do I query on today's date. I apparently have the wrong syntax
because
I'm constantly getting error messages.

In the criteria, I have =Today(). What are the exact characters I should
be
putting in the criteria box to get todays date only? I do not want the
user
typing in the date every time he refreshes data.

Thanks for the help.




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default Today's Date in MS Query

Lambi000, this is an Excel newsgroup not Access, but try this and see if it
will work Date()
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Lambi000" wrote in message
...
How do I query on today's date. I apparently have the wrong syntax
because
I'm constantly getting error messages.

In the criteria, I have =Today(). What are the exact characters I should
be
putting in the criteria box to get todays date only? I do not want the
user
typing in the date every time he refreshes data.

Thanks for the help.



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Today's Date in MS Query

There is nothing built in, here's from an answer by Debra Dalgleish to a
similar question

http://tinyurl.com/2nmocy


--
Regards,

Peo Sjoblom


"Lambi000" wrote in message
...
Hi Paul,
I'm using Excel. I have external data and I'm filtering it with MS Query.

I tried Date() and it didn't work. Thanks!

"Paul B" wrote:

Lambi000, this is an Excel newsgroup not Access, but try this and see if
it
will work Date()
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Lambi000" wrote in message
...
How do I query on today's date. I apparently have the wrong syntax
because
I'm constantly getting error messages.

In the criteria, I have =Today(). What are the exact characters I
should
be
putting in the criteria box to get todays date only? I do not want the
user
typing in the date every time he refreshes data.

Thanks for the help.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting for cell date to equal today's date Sistereinstein Excel Worksheet Functions 2 September 10th 12 07:53 PM
I need today's date returned as date format in formula CMIConnie Excel Discussion (Misc queries) 2 February 23rd 06 05:38 PM
Count number of cells with date <today's date Cachod1 New Users to Excel 2 January 28th 06 03:37 AM
count the number of cells with a date <= today's date Cachod1 New Users to Excel 3 January 27th 06 10:14 PM
How do I sum a range if the date is is greater than today's date? S2 Excel Worksheet Functions 4 October 8th 05 08:11 PM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"