jt wrote:WHERE Call_Date >= #2004/04/01# AND Call_Date < DATEADD("d",1,#2004/04/01#)> Hi,
> I'm trying to do a sql query on a date column, like this
> SELECT * FROM [PSUSA] WHERE Call_Date = #04/01/2004#
> No errors in the statement, but 0 recordsets found. I have plenty
> dates with this.
> Also, my actual contents in Call_Date field has time as well. I just
> need to query on dates not time.
> Example how the data is in the field. "4/23/2004 10:59:15 AM"
> Any ideas what I could be doing wrong. Us MS Access 2002 version.
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the