How can I retrive records which have been entered into the database today? Input-date has formatted as follows: dd-mmm-yy hh:nn:ss
I've tried Now() and Date() functions in the criteria but it doesn't seem to work.

Help you guy, PLEASE

Hi Princess,
What you need to do is stip time portion from your date. Create a new field in your query like this:

=CDate(Format([DateField],"m-d-yy"))

Then use Date() as the criteria for that field. Good luck.

~Abby

Try this:

Query:

DateEntered: Criteria set to:

>now()-1<now()

I often use an unbound form asking for parameters and then set the query criteria to >Forms!UnboundForm!BeginningDate and <=Forms!UnboundForm!EndingDate

Hope that helped a little.