A volunteer organization that I work with has a database to keep track of our clients who are mainly elderly.
In that database is a form to record new clients which contains a field for 'Date of Birth'. However, unless you put the year in as YYYY, it will default to 20YY. Is there any way to get it to default to 19YY?
Seems like it should be a simple tweak, but I can't find it anywhere.
While you could change the Operating System settings to adjust how the system interprets 2-digit years, this would require changing every OS you're working with, if they allow such change.
A better way, that fixes the problem now AND allows for future appropriate adjustment, would be to rewrite the database, probably the form itself, to pre-enter the first 2 digits into the field as it generates. This would allow quick entry of the final two digits, saving time, while also allowing for the pre-entered digits to still be modified if necessary.
Depending on usability concerns, you could have the first 2 digits be in a different field, so tabbing along between fields wouldn't highlight them as an existing value (the default behavior when tabbing between fields).
I strongly suggest that doing this will make your database easier to work with correctly, requires less (or no) change to the system you're running the database on, and solves the problem today while also allowing the system to be updated in the future if you're still using the same system when people born after 2000 are beginning to be considered "aged".