Hi, welcome to the forum.
It's probably clear for you but ...
The linked cell date entry is "Jan-19", that is what you SEE but the actual value is probably the actual date, correct?
Do NOT mistake the date format with the date value.
Suggestion:
Add a temporary date variable that fills the date based on the textbox in the format :
Something like that, play around with it
You can also do an extra check to check if the new Year(tmpDate) is between 2018 and 2065 before comitting
This just typed, not checked for syntax errors, but just to give you an idea how it could be done,, there are probably other ways but this is my idea for doing it.
Bookmarks