Need Help With SQL

[sgfromny]

can Anyone help with the SQL code I would need to select the following in a DAO recordset:

A. designer = me.designer
B. Status = "IN"
and my trouble...
C. TimeStamp = date() and ANY TIME.

Timestamp Field is stored with Date AND time, Im searching for the date in that field only.

 

[PHV]

Something like this ?
CLng(TimeStamp) = CLng(Date())

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sgfromny]

I dont Think so...

My record has "8/31/04 12:21:34PM"
Im Looking to find this record using only 8/31/04

 

[PHV]

A timestamp is a number: integral part=number of days, decimal part=number of seconds.
If DAO choke on CLng, you may try this:
Int(TimeStamp) = Int(Date())
I dont Think so...
Have you tried it ? any error message ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244