By Richard Rost 2 years ago
Create a List of Birthdays using DateSerial
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?
Members will learn how to calculate an exact list of customers who have birthdays in the following calendar month. So if it's currently October, you can see everyone who has a birthday in the month of November.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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, store only month and day
Subscribe to Birthdays
Get notifications when this page is updated
|Keywords: TechHelp Access 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, month day only, missing year no year without year PermaLink Birthdays in Microsoft Access|