How To Use DateSerial in Microsoft Access to Create a Valid Date Value From the Year, Month, and Day
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.
LEARN MORE:
https://599cd.com/DateSerial
PRE-REQUISITES:
Calculated Fields: https://599cd.com/Calculated
RECOMMENDED COURSES:
Access Expert 27: https://599cd.com/ACX27
Access Expert 28: https://599cd.com/ACX28
Access 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
BECOME A MEMBER:
YouTube: / @599cd
or My Site: https://599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$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
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.