Move Any Dates Entered MM-DD to the Future

In this Microsoft Access tutorial, I'm going to show you how to make dates entered as MM-DD always become future dates. This is great for setting appointments, follow-ups, or other calendar items. This way, if you're entering appointment dates and the month and day are before today's date in the year, they won't automatically get set to past dates. For example, today is December 14, 2022. If I am setting a future appointment and I type in "02-24" in my date field, Access will assume I mean this year, so I get 2022-02-24. In this video, I'll show you how to make it default to 2023-02-24. 

Gianna from Point Pleasant, New Jersey (Platinum Member) asks: I have a database where I enter a lot of appointments. These dates will always be in the future. If it's currently December, and I type in 2/20, then the database assumes I mean 2/20 of this year. Is there any way to make it advance to next year if the date is in the past?

Members

Members will learn how to turn this into a function so that it can be used by any date field in your database very easily. We will also add some code to allow the user to specify the year, which will then not change the date. If they enter only the month and day, then the function will modify the year accordingly. Otherwise, if they do specify the year, it will keep exactly that year.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members
• VBA Source Code: Code Vault - Gold Members

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!

Pre-Requisites

• Intro to VBA: https://599cd.com/IntroVBA
• After Update: https://599cd.com/AfterUpdate
• If Then: https://599cd.com/IfThen
• DateSerial: https://599cd.com/DateSerial
• Year Month Day: https://599cd.com/YMD

Links

• ISO Date Format: https://599cd.com/ISO
• Limit Long Text: https://599cd.com/LimitLongText

Recommended Courses

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

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 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, date next year, future date, force dates to next year, upcoming appointment dates, followup dates, future payments, text property, move date to future, always specify future year