Create a Date From Year, Month, Day with DateSerial

In this Microsoft Access tutorial, I will show you how to take the individual date components (year, month, and day) and assemble them into a valid Date value that you can store in a Date/Time field.

Zack from Mesa, Arizona (a Gold Member) asks: When we first started our business a few years ago, we only tracked the year and month that our customer's joined as members. How can we convert that data to real dates so we can use them properly in Access? I want to perform calculations, like sending rewards for customers after 10 years, but I don't know how with just month and year. 

Pre-Requisites

• Calculated Fields: https://599cd.com/Calculated

Recommended Course

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

Usage

• NewDate: DateSerial(MyYear, MyMonth, MyDay)

Links

• Birthdays: https://599cd.com/Birthdays
• Update Queries: https://599cd.com/UpdateQ
• What is Null: https://599cd.com/IsNull
• ISO Date Format: https://599cd.com/ISO

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, DateSerial Function, get date value from month day year, month day year to date, How to use DateSerial function to get a date in MS Access