Hi,

I have a field DateStamp, stores both date and time. I would like put a
query with which I can only compare date but not the time. I put this query
but it is not working. Please help thankx..

SELECT transactions.ChangeRequest FROM transactions WHERE 1=1 AND
transactions.[Date Request] = #5/31/2004# ORDER BY transactions.Status

Thankx

Hi,

I tried datevalue() function but it gave me following error.

Data type mismatch in criteria expression.
/helpdesk/HelpDesk/HelpDesk.asp, line 400

I am using HTML as front end and ASP for database access.. thankx in
advance..

Tausif

Does this work for you?

WHERE (((Str(transactions.[Date Request])) Like "*" & "5/31/2004" & "*"))

Try not to get into the habit of treating dates like text. MtAlam's original statement is correct using the # delimiter for dates, but I do have one question. What is the purpose of the WHERE 1 = 1 portion of your statement?

Perhaps you should change that to

And if you're doing this on a form where the date request is on a textbox, then

Where you replace Me.txtDateRequest with the real name of your textbox.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I saw nothing strange with the "1=1" part. I cannot speak for mtalam, but I have used 1=1 for years as a quick way to en/dis -able certain functions. Make it 1=0 to disable, and 1=1 to enable it.

Ahhhhh... so that's what that's for. I just comment / uncomment the function.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division