• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 928
  • Last Modified:

Criteria to Exclude Date

Some time ago I wrote records away to a table using the now() command - so date and time was recorded

Now I wish to exclude records by entering the date only (without the time) in a query

What is the easiest way of doing that?

Thanks
0
Zarbs
Asked:
Zarbs
  • 3
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
use date() instead of now()
0
 
ZarbsAuthor Commented:
I particularly wish to write away the time.  The problem is that I don't want to enter it when I wish to exclude these records.  Can I convert the date in the table before doing the compare?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Use DataValue([YourDateField]) to filter against the date only

mx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"Can I convert the date in the table before doing the compare?"

Yes .. using an update query ... updating to the DataValue([YourDateField])

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
For example:

UPDATE Table1 SET Table1.FIELD1 = DateValue([FIELD1]);

mx
0
 
ZarbsAuthor Commented:
Used Datevalue

Thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now