By Richard Rost 15 months ago
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.
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
Subscribe to DateSerial
Get notifications when this page is updated