Specific Date usung a Where clause

  • Thread starter Thread starter leffler
  • Start date Start date
L

leffler

I am able to get a range of dates using a the following

Between [Type Begining Date:] And [Type Ending Date]

I cannot get just a single date. ie one day versus a range.

Can anyone help?
 
Unless your date field includes time. Time is stored as decimal part of the
date.
Then you need to strip time off of it.
Use criteria on calculated field like this --
MyDate: Int(YourDateField])
Then use the #3/13/2009# criteria.
 
You must log in or register to reply here.

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

where clause 3
Create a Query that Prompts for Date and Time 4
DateDiff function throwing error in Where clause 7
Date Range Pulling Only Month 1
Date Range - Between Start and End 5
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Comparing date ranges 2
...cannot use a calculated field in a Where clause... 2

Back
Top