Retriving data using date as criteria.

[princess15s]

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

 

[Abby N]

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

 

[jwindon]

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.