How to Query Records by Date in Microsoft Access Up to, But Not Including Midnight

In this Microsoft Access tutorial, we'll tackle the challenge of querying records up to 11:59:59 PM with specific criteria tailored for a meticulous request. You'll learn how to adjust query criteria, use date functions like DateAdd, and implement VBA for seamless form integration.

Dylan from Newton, Iowa (a Gold Member) asks: Using a technique similar to your "Value From a Form" video, I have two text boxes on my main menu to specify a start date/time and an end date/time for a query that shows orders within that time range. I want the default to be all orders from yesterday because we check it daily. I had it set to greater than or equal to Date()-1 and less than Date() for the criteria, but my stubborn boss insists that the end date/time in the query criteria should explicitly be 11:59:59 PM instead of using simpler logic. How can I handle this requirement?

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
Up To Midnight: https://599cd.com/UpToMidnight

PREREQUISITES:
Query Criteria: https://599cd.com/Criteria
Value From a Form: https://599cd.com/FormName
DateAdd: https://599cd.com/DateAdd

LINKS:
Date Math: https://599cd.com/DateMath
Between Wrong: https://599cd.com/Between
Intro to VBA: https://599cd.com/IntroVBA

RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer
Access Expert 1: https://599cd.com/ACX1L

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, query records by date, excluding midnight, 11:59:59 PM criteria, date add function, subtracting one second, custom date format, VBA button creation, Access query setup, non-VBA alternative, TechHelp tutorial

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.