[h=1]I am creating a library database system which contains a table called "loan". The loan table contains the book id, borrower, and date/time. How would I create a query to show me the books that were loaned between yesterday's 5pm and today's 9am?[/h]
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,140
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
The key thing to understand is how Access and Excel store dates. They store them as numbers, specifically the number of days since 1/0/1900. And time is just the fraction of a day. So 9:00 AM could be represented by 9/24.
So, to get a date/time range between 5:00 PM the previous day and 9:00 AM today, you could use this as the Criteria in your Date field in your Query:
The key thing to understand is how Access and Excel store dates. They store them as numbers, specifically the number of days since 1/0/1900. And time is just the fraction of a day. So 9:00 AM could be represented by 9/24.
So, to get a date/time range between 5:00 PM the previous day and 9:00 AM today, you could use this as the Criteria in your Date field in your Query:
Code:
Between (Date()-(7/24)) And (Date()+(9/24))
Upvote
0
Similar threads
- Solved
