DanG
Registered User.
- Local time
- Today, 05:13
- Joined
- Nov 4, 2004
- Messages
- 477
I have a "Client" table which has a "Date of Birth" field and the problem I am having is on in the data entry form the users type in "2/25" instead of "2/25/1965" on for the most part that's OK. But if the client DOB is 1930 or before then 2/25/2029 comes up.
I have found that the date format is tied to the Windows Regional settings and we are working on a network that doesn't allow me to adjust the settings.
I have tried to put a validation on the table for the field but then that makes it so you HAVE to enter something and can not leave that field blank if you want.
Any ideas?
I have found that the date format is tied to the Windows Regional settings and we are working on a network that doesn't allow me to adjust the settings.
I have tried to put a validation on the table for the field but then that makes it so you HAVE to enter something and can not leave that field blank if you want.
Any ideas?