Query Date without comparing time

[Bosco]

I have a datetime field in a table stored in Sql Server. I haev a access query that I am trying to allow a user to input a date and select all the records that correspond to that date.

=[Beginning Date: 'mm/dd/yyyy']

The problem is that the date the user types in is:

06/24/2010

But the date in the database has:

06/24/2010 10:24:00:00

So no records return.

There has to be an easy way to query anything with just the date portion matching regardless of the time???



Thanks for your help.....

[ConneXionLost]

Use this in the query to modify your datetime field:

DateOnly: DateValue([yourdatetimefieldname])

Cheers,

[Bosco]

Thanks....
So I would just put

= DateOnly: DateValue([Start Date] in the criteria field of the query column?

I just want the user to enter a date and then only select records with that date.

Thanks!!

[Rawb]

You'd do something like this (I use Format([field], "Short Date") instead of DateValue([field]), but they both should work!).

[Rawb]

Note: Use ConneXionLost's version of DateValue([field]).

If you use my method, the data is treated as a text string and not an actual date. This can lead to funky sorting results.

[ConneXionLost]

If you're still having difficulty, post the SQL of your Access query.

Cheers,