Microsoft Access DatePart Function: Get Specified Part of a Date (Year, Quarter, Month, Week, etc.)

In this video I will show you how to use the DatePart function to isolate specific parts of a date/time value such as the day of the year, week of the year, month, quarter, and so on. DatePart offers some options that other functions don't have.

Damon from Waterville, Ohio (a Platinum Member) asks: I have a query that shows sales for the year, but right now I have to type in the start date (say 1/1/2021) and the end date (12/31/2021) and it's a bit of a pain EVERY time I run the query. Is there any way I can simplify that to just type in the year only?

Silver Members and up get access to an Extended Cut of this video. Members will learn about the FirstDayOfWeek and FirstWeekOfYear options, how to determine if a date falls within the same calendar week as the current date, and how to determine if a date falls in the same quarter of the current year.

MEMBERS VIDEO:
   • Microsoft Access DatePart Function ME...  

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

LEARN MORE:
https://599cd.com/DatePart

LINKS:
Query Criteria: https://599cd.com/Criteria
Calculated Query Fields: https://599cd.com/Calculated
Parameter Query: https://599cd.com/Parameter
Between Keyword: https://599cd.com/Between
Enter Parameter Value: https://599cd.com/EPV
Value From Open Form: https://599cd.com/FormName
Microsoft DatePart: https://tinyurl.com/ya8hkb4x

SUGGESTED COURSES:
Access Expert 27: https://599cd.com/ACX27
Access Expert 28: https://599cd.com/ACX28
DateTime Seminar: https://599cd.com/DateTime

OTHER COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

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:
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:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, DatePart, parts of a date, year, quarter, month, day of year, week, week of year, weekday, week number, hour, minute, second, first week of year, first day of week, Date in current week of year, DatePart Function, How do you calculate quarters in Access, How do I extract month and year from date in Access

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.