When I enter a date prior to 1930 it shows up as 2000 for example 1929 would be 2029. How do I fix this? I have a form where ages are calculated and when a person is born prior to 1930 it will not calculate properly.
When I enter the current date and then a birth date to calculate the age and the birth date is before 1930 it gives me a negative number. For example if I enter 01-11-17 and the birth date of 01-26-29 it gives an age of -13.
It is currently in a text field but gives the same result in a date field.
I can send you the form if need be, but I guess I can't attach an attachment through here.