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.
 
Back
Top