Birthday

  • Thread starter Thread starter EllenM
  • Start date Start date
E

EllenM

Hello
I have a birthday field (mm/dd) that somehow or other got converted to
mm/dd/yyyy when I imported from Excel. It has everyone being born in 2007.
How do I change it to mm/dd?

Thanks in advance,
Ellen
 
Date fields must contain complete dates.

You'd have to either add a new Text field and update it using
Format([Birthdate], "mm/dd"), or two new numeric fields (one for month and
one for day), and update them using Month([Birthdate]) and Day([Birthdate])
 
On the other hand, why do you care what year is stored with the date.
Although the birthdate is inaccurate, the birthday (month and day) is
still the same.

For searching you can use criteria like
Field: Format(Birthdate,"mmdd")
Criteria: "1206"

You can display the day and month using format to control the display of
the information.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
I agree philosophically. I'd just be concerned that if you've got a field in
there saying that someone's birthdate is 08 Dec, 2007, someone's going to
take it literally...

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


John Spencer said:
On the other hand, why do you care what year is stored with the date.
Although the birthdate is inaccurate, the birthday (month and day) is
still the same.

For searching you can use criteria like
Field: Format(Birthdate,"mmdd")
Criteria: "1206"

You can display the day and month using format to control the display of
the information.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Date fields must contain complete dates.

You'd have to either add a new Text field and update it using
Format([Birthdate], "mm/dd"), or two new numeric fields (one for month
and one for day), and update them using Month([Birthdate]) and
Day([Birthdate])
Click to expand...
Click to expand...
 
You're quite helpful as usual. How would I add the "/" in a report?

John Spencer said:
On the other hand, why do you care what year is stored with the date.
Although the birthdate is inaccurate, the birthday (month and day) is
still the same.

For searching you can use criteria like
Field: Format(Birthdate,"mmdd")
Criteria: "1206"

You can display the day and month using format to control the display of
the information.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Date fields must contain complete dates.

You'd have to either add a new Text field and update it using
Format([Birthdate], "mm/dd"), or two new numeric fields (one for month and
one for day), and update them using Month([Birthdate]) and Day([Birthdate])
Click to expand...
Click to expand...
 
Your code worked perfectly. Thanks, so much Doug. Of course, it goes
without saying that us women hide our age so we'll look younger.

Ellen
 
Format(BirthDate,"mm/dd")

OR set the format property of the control to

mm/dd




'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

You're quite helpful as usual. How would I add the "/" in a report?

John Spencer said:
On the other hand, why do you care what year is stored with the date.
Although the birthdate is inaccurate, the birthday (month and day) is
still the same.

For searching you can use criteria like
Field: Format(Birthdate,"mmdd")
Criteria: "1206"

You can display the day and month using format to control the display of
the information.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Date fields must contain complete dates.

You'd have to either add a new Text field and update it using
Format([Birthdate], "mm/dd"), or two new numeric fields (one for month and
one for day), and update them using Month([Birthdate]) and Day([Birthdate])
Click to expand...
Click to expand...
Click to expand...
 
Back
Top