I want to post only the month and day of a person's birthday in Access. I do not have the year. Can I do this and how?
Kevin Robertson
@Reply 12 months ago
Enter the day and month. Example: 20/06
This will also give you the current year but you can Format the date in the After Updateevent.
txtMyDate = Format(txtMyDate, "dd/mm")
If your regional settings are like mine (ISO Date Format) the result will be 20-06.
To get the correct format in this case write the code like this:
txtMyDate = Format(txtMyDate, "dd\/mm")
This will force the correct format.
I do this in code because with the Format property, on the Property Sheet, if you click on the field the full date will be displayed.
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
Visitor Forum.
