|
||||||
|
Future Dates Only By Richard Rost ![]() ![]() 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? MembersMembers 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! Pre-Requisites
Links
Recommended Courses
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
|
||||||||||||||||||||
| |||
Keywords: TechHelp Access 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 PermaLink Future Dates Only in Microsoft Access |