Data Entry Form: How to cut the short date to just mm/dd/yy and have the century (19or20) autofill

[ExtremeNovice]

I have a data entry form where I will be entering customer birth dates. I will have several hundred customers a day so every keystroke that I can cut out is a win. I have my birth dates in short date format and I would like to cut out the first two year numbers from the data entry process. The challenge is some birth dates are in 1900's and some are in the 2000's. What is the best set it up where I can enter a date in MM/DD/YY format and have the correct century (19 or 20) auto fill. I am not concerned about customers that are over 100 years old and, obviously there will never be birthdays that are beyond the current date.


Thanks!

[CJ_London]

so basically if date enter is greater than today, you want to deduct 100 years

if so then in the date control afterupdate event put

if mydatecontrolname>=date() then mydatecontrolname=dateadd("yyyy",-100,mydatecontrolname)

you may need to change date() to an earlier date (use the dateadd function to deduct required number of years or alternatively use a specific date) since your post is not clear as to when to deduct 100 years - for example someone born in 2016 or 1916?