remove year from birthday

[Guest]

I have a short date field, BIRTHDAY, with the input mask of 99/99/00;0, in
table CONTACTS. I would like to remove the year and then sort the birthdays
by month and day via a query to mail merge with MS Word to send out birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Rick B]

First, you don't have to modify the query each month, just make the month of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")

 

[Guest]

Rick, WONDERFUL and thank you. May I push for another level? I believe the
greeting would look more professional reading "September 3" as compared to
"09/03." Would you please help me convert it to the month spelled out and
date? Your answer was in a fraction of the time I spent searching in how to
do this.
Respectfully, Frank

First, you don't have to modify the query each month, just make the month of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B

I have a short date field, BIRTHDAY, with the input mask of 99/99/00;0, in
table CONTACTS. I would like to remove the year and then sort the birthdays
by month and day via a query to mail merge with MS Word to send out birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Rick B]

I believe that would be:

BirthdateRevised: Format([birthdate],"mmmm dd")



--
Rick B

Rick, WONDERFUL and thank you. May I push for another level? I believe the
greeting would look more professional reading "September 3" as compared to
"09/03." Would you please help me convert it to the month spelled out and
date? Your answer was in a fraction of the time I spent searching in how to
do this.
Respectfully, Frank

First, you don't have to modify the query each month, just make the month of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B

I have a short date field, BIRTHDAY, with the input mask of 99/99/00;0, in
table CONTACTS. I would like to remove the year and then sort the birthdays
by month and day via a query to mail merge with MS Word to send out birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Guest]

MR. Rick B: THANK YOU very much for your time and assistance. Have a
pleasant day; I will now! Frank

I believe that would be:

BirthdateRevised: Format([birthdate],"mmmm dd")



--
Rick B

Rick, WONDERFUL and thank you. May I push for another level? I believe the
greeting would look more professional reading "September 3" as compared to
"09/03." Would you please help me convert it to the month spelled out and
date? Your answer was in a fraction of the time I spent searching in how to
do this.
Respectfully, Frank

First, you don't have to modify the query each month, just make the month of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B



I have a short date field, BIRTHDAY, with the input mask of 99/99/00;0, in
table CONTACTS. I would like to remove the year and then sort the
birthdays
by month and day via a query to mail merge with MS Word to send out
birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Steve Schapel]

Or, to be totally precise...
BirthdateRevised: Format([birthdate],"mmmm d")

 

[Bob''s Wife]

So how can I sort my table? I was able to remove the year doing what you
said, but now it will not let me sort the table so I see the birthdays in
chronological order. And the year in the birthday field is what causes them
to sort improperly.

First, you don't have to modify the query each month, just make the month of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B

I have a short date field, BIRTHDAY, with the input mask of 99/99/00;0, in
table CONTACTS. I would like to remove the year and then sort the birthdays
by month and day via a query to mail merge with MS Word to send out birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Douglas J. Steele]

Did you add the BirthdateRevised field to your query like Rick suggested?
Sort on that field, not the birthdate.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

So how can I sort my table? I was able to remove the year doing what you
said, but now it will not let me sort the table so I see the birthdays in
chronological order. And the year in the birthday field is what causes
them
to sort improperly.

First, you don't have to modify the query each month, just make the month
of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B

I have a short date field, BIRTHDAY, with the input mask of 99/99/00;0,
in
table CONTACTS. I would like to remove the year and then sort the birthdays
by month and day via a query to mail merge with MS Word to send out birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Mary]

I added the following to my query:
(In an empty field BirthdateRevised: Format([BirthDate],"mm/d")
(Criteria Between [Enter start date:] And [Enter end date:]

If I query 10/3 (start date) to 10/5 (end date) then in addition to 10/3,
10/4 and 10/5 it returns all dates starting with 10/3 such as 10/30 and
10/31

If I query 10/1 (start date) to 10/3 (enddate) then in addition to 10/1,
10/2 and 10/3 it returns all dates beginning with 10/1, 10/2, or 10/3 such as
10/1, 10/10, 10/11, 10/12, 10/13... 10/20, 10/21... 10/30, 10/31 etc.

Is there a fix for this?

Did you add the BirthdateRevised field to your query like Rick suggested?
Sort on that field, not the birthdate.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

So how can I sort my table? I was able to remove the year doing what you
said, but now it will not let me sort the table so I see the birthdays in
chronological order. And the year in the birthday field is what causes
them
to sort improperly.

First, you don't have to modify the query each month, just make the month
of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B



I have a short date field, BIRTHDAY, with the input mask of 99/99/00;0,
in
table CONTACTS. I would like to remove the year and then sort the
birthdays
by month and day via a query to mail merge with MS Word to send out
birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Douglas J. Steele]

Use Format([BirthDate],"mm/dd"), and use preceding zeroes, so that you enter
10/03 and 10/05, not 10/3 and 10/5.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I added the following to my query:
(In an empty field BirthdateRevised: Format([BirthDate],"mm/d")
(Criteria Between [Enter start date:] And [Enter end
date:]

If I query 10/3 (start date) to 10/5 (end date) then in addition to 10/3,
10/4 and 10/5 it returns all dates starting with 10/3 such as 10/30 and
10/31

If I query 10/1 (start date) to 10/3 (enddate) then in addition to 10/1,
10/2 and 10/3 it returns all dates beginning with 10/1, 10/2, or 10/3 such
as
10/1, 10/10, 10/11, 10/12, 10/13... 10/20, 10/21... 10/30, 10/31 etc.

Is there a fix for this?

Did you add the BirthdateRevised field to your query like Rick suggested?
Sort on that field, not the birthdate.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

So how can I sort my table? I was able to remove the year doing what
you
said, but now it will not let me sort the table so I see the birthdays
in
chronological order. And the year in the birthday field is what causes
them
to sort improperly.

:

First, you don't have to modify the query each month, just make the
month
of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B



I have a short date field, BIRTHDAY, with the input mask of
99/99/00;0,
in
table CONTACTS. I would like to remove the year and then sort the
birthdays
by month and day via a query to mail merge with MS Word to send out
birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.

 

[Mary]

Worked like a charm. Thank you very much!

Use Format([BirthDate],"mm/dd"), and use preceding zeroes, so that you enter
10/03 and 10/05, not 10/3 and 10/5.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I added the following to my query:
(In an empty field BirthdateRevised: Format([BirthDate],"mm/d")
(Criteria Between [Enter start date:] And [Enter end
date:]

If I query 10/3 (start date) to 10/5 (end date) then in addition to 10/3,
10/4 and 10/5 it returns all dates starting with 10/3 such as 10/30 and
10/31

If I query 10/1 (start date) to 10/3 (enddate) then in addition to 10/1,
10/2 and 10/3 it returns all dates beginning with 10/1, 10/2, or 10/3 such
as
10/1, 10/10, 10/11, 10/12, 10/13... 10/20, 10/21... 10/30, 10/31 etc.

Is there a fix for this?

Did you add the BirthdateRevised field to your query like Rick suggested?
Sort on that field, not the birthdate.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


So how can I sort my table? I was able to remove the year doing what
you
said, but now it will not let me sort the table so I see the birthdays
in
chronological order. And the year in the birthday field is what causes
them
to sort improperly.

:

First, you don't have to modify the query each month, just make the
month
of
the birthdate equal to the month of the current date (or next month or
whatever)

=Month(date())

To do what you want, format the field...
BirthdateRevised: Format([birthdate],"mm/dd")



--
Rick B



I have a short date field, BIRTHDAY, with the input mask of
99/99/00;0,
in
table CONTACTS. I would like to remove the year and then sort the
birthdays
by month and day via a query to mail merge with MS Word to send out
birthday
cards. I am willing to go into the query on a monthly basis asking
specifically for birthdays that month. Your help will be greatly
appreciated.