Specific Date usung a Where clause

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?
 
K

KARL DEWEY

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