querying dates with times

[LHR]

I have a date time field in which I want to remove the time but nothing seems to be working so I'm trying to live with it.

So I need to search for a range of dates in a query:
between [enter start date] and [enter end date]

If I want to get just today's dates I am entering 8/5/03 in both parameters for start and end.

Because of the times in the fields I cannot get just this date. I have to enter 8/5/03 and 8/6/03.

Any help would be appreciated. Either a way to ignore the times in the date fields or a way to remove the times completely. The data was imported this way..

Thanks a bunch!

 

[Waltang]

Do you have an = in the criteria?

>= [Startdate] and <= [Enddate]

 

[LHR]

Got it!

I am using a between and statment.

In searching through more of the postings I found the field:datevalue(datefield) option and this has worked like a charm so thank you, this site is fantastic!

I find most of my answers searching through others...

Thanks for your quick response!