All records after a specified time

[rewdee]

I want to return all records from a table after a certain date and a specified time.

The table has two fields (PID->long and [Date/Time]->date/time.

I've tried:

SELECT Visits.PID, Visits.[Date/Time]
FROM Visits
WHERE Visits.[Date/Time]>Date()-7 And format(Visits.[Date/Time],"Short Time")>#4:00 PM#

Can someone help me this query?

Thanks,
Rewdee

 

[jstiegelmeyer]

Hi, try this:

SELECT Visits.PID, Visits.[Date/Time]
FROM Visits
WHERE Visits.[Date/Time] BETWEEN Date()-7 AND Date()-7+#4:00 PM#

Thanks,
Jamie

 

[rewdee]

Thanks for your reply Jamie.

Thanks to your post, I'm moving in the right direction. The query you posted returns all records between my opening time and 4:00 PM.

Ultimately, what I want is to return all visits (records) of visits after 4:00 PM between two dates. eg. Sept 9 all visits after 4:00 PM and Sept 10 all visits after 4:00 PM, etc.

Any ideas how to proceed?

Thanks,
Rewdee

 

[jstiegelmeyer]

SELECT Visits.PID, Visits.[Date/Time]
FROM Visits
WHERE Visits.[Date/Time] BETWEEN #9/9/03 4:00 PM# AND #9/10/03 12:00 AM#
OR Visits.[Date/Time] BETWEEN #9/10/03 4:00 PM# AND #9/11/03 12:00 AM#