I have designed a BirthDay field with date/time. Problem is I do not have everyone's year of birth. Would like to have the choice of dd/mm or dd/mm/yyyy but when I just enter dd/mm, Access automatically inserts current year.
Reply from Richard Rost:
That's a problem. You have to have a YEAR component to enter a valid date. Your options are to either (a) use separate fields to capture MONTH and DAY, or (b) enter in some old, impossible value, like 1900 as the year if you don't know the year.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
