Query date/time issues

  • Thread starter Thread starter sbatschelet
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count records in 10 minute time period 4
Format of Date/Time 1
querying unrelated tables 7
separating date and time 5
Changing constants in a query to user input values 2
Pivot table macro filter data between yesterday and today (date+time) 0
Time Difference 9
Counts number of entries per day in query 4

Back
Top