Query date/time issues

S

sbatschelet

I am running into a problem with doing a simple query on a date/time
field in a MSA 2000 database. I have googled around but for some
reason I can't get a generic answer in regards to the formatting of a
date/time query.

Basically I am looking to create this:

Select Payments.Value, Payments.CCType, Payments.Payee,
Payments.PayDate
From Payments
Click to expand...
Where Payments.PayDate BETWEEN #5/20/2005 00:00:01 AM# AND "Now()"

But I am certain that I am wrong with my formatting of data/time
5/20/2005 00:00:01 AM how can I format 5/20/2005 00:00:01 AM to achieve
the correct output? The Idea is I want to find every record with time
stamp from the start of the day to now.

Thanks
Sam
 
Top