Suppress "year" in a date field

  • Thread starter Thread starter Patti
  • Start date Start date
P

Patti

I have a database that I need to run a query on that will
show a person's birthday and month but not the year that
person was born in. I remember learning how to do this
in school but it has been 8 years since I got out.

Thanks in advance for your help.

Patti
 
Patti,

In your query, you could use:

MonthDay: Format([BirthDate], "mm/dd")

or, to spell out the Month:

MonthDay: Format([BirthDate], "mmm dd")

hth,
 
I have been working on this issue for a couple of weeks (I'm a newbe and
learning) I had this same question and while I was able to get the "mmm dd"
returned , and can sort by Month in alphabetical order, can I sort this in
chronological order?

Jim

Thanks for any replies
Cheryl Fischer said:
Patti,

In your query, you could use:

MonthDay: Format([BirthDate], "mm/dd")

or, to spell out the Month:

MonthDay: Format([BirthDate], "mmm dd")

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Patti said:
I have a database that I need to run a query on that will
show a person's birthday and month but not the year that
person was born in. I remember learning how to do this
in school but it has been 8 years since I got out.

Thanks in advance for your help.

Patti
Click to expand...
Click to expand...
 
Create 2 computed fields: one that uses mmm dd, and another that uses mm dd.
Sort on the second one, not the first one.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



C & J Jones said:
I have been working on this issue for a couple of weeks (I'm a newbe and
learning) I had this same question and while I was able to get the "mmm dd"
returned , and can sort by Month in alphabetical order, can I sort this in
chronological order?

Jim

Thanks for any replies
Cheryl Fischer said:
Patti,

In your query, you could use:

MonthDay: Format([BirthDate], "mm/dd")

or, to spell out the Month:

MonthDay: Format([BirthDate], "mmm dd")

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Patti said:
I have a database that I need to run a query on that will
show a person's birthday and month but not the year that
person was born in. I remember learning how to do this
in school but it has been 8 years since I got out.

Thanks in advance for your help.

Patti
Click to expand...
Click to expand...
Click to expand...
 
Douglas,
Thanks for the reply, I tried the two columns and it worked to a point,
now sorting by month (chronological order) then by ID number (primary key) .
I had to go to a third column but managed to get the desired results.

Also I would like to thank ALL those who post questions and solutions here I
have learned allot that I have not been able to find in the books!

Jim

Douglas J. Steele said:
Create 2 computed fields: one that uses mmm dd, and another that uses mm dd.
Sort on the second one, not the first one.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



C & J Jones said:
I have been working on this issue for a couple of weeks (I'm a newbe and
learning) I had this same question and while I was able to get the "mmm dd"
returned , and can sort by Month in alphabetical order, can I sort this in
chronological order?

Jim

Thanks for any replies
Cheryl Fischer said:
Patti,

In your query, you could use:

MonthDay: Format([BirthDate], "mm/dd")

or, to spell out the Month:

MonthDay: Format([BirthDate], "mmm dd")

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


I have a database that I need to run a query on that will
show a person's birthday and month but not the year that
person was born in. I remember learning how to do this
in school but it has been 8 years since I got out.

Thanks in advance for your help.

Patti
Click to expand...
Click to expand...
Click to expand...
 
Back
Top