Create a List of Birthdays in Microsoft Access using the Month, Day, and DateSerial Functions

Описание: ADDENDUM: I didn't take January birthdays into consideration in the original video. This addendum addresses that issue: https://599cd.com/Birthday

In this video, I'll show you how to use the DateSerial function to build a valid date value based on the year, month, and day parts in Microsoft Access. You can use this to determine who has a birthday coming up in the next 30 days.

Gillian from Reno, Nevada (a Platinum Member) asks: I'm in the restaurant business. We ask our customers for their date of birth so we can give them a free dinner on their birthday, but most people only give month and day, not the year, and that's OK. Problem is, how do I store that in my table? Also, how can I tell who has a birthday coming up in the next 30 days so I can send them a gift card?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to calculate an exact list of customers who have birthdays in the following month. So if it's currently October, you can see everyone who has a birthday in the month of November.

MEMBERS VIDEO:
   • Birthdays. MEMBERS ONLY EXTENDED CUT. Next...  

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

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

LINKS:
Query Criteria: https://599cd.com/Criteria
Parameter Query: https://599cd.com/Parameter
Validation Rules: https://599cd.com/ValidationRules
Access Expert 27: https://599cd.com/ACX27

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, list of birthdays, list of anniversaries, birthdays today, birthdays this week, birthdays this month, birthdays in current month, birthdays next month, birthdays within the next 30 days, birthday calendar, month function, day function, dateserial function, birthday this year, data type mismatch, problem list for microsoft

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