Month and Day only

  • Thread starter Thread starter Maz
  • Start date Start date
M

Maz

I would like to run a query which selects all the dates from a date of Birth
field (dob) that picks out the birthdays of that date irrespective of the
year.

Thanks in advance to anyone that can help me.

Maz T
 
Maz,

Does it give what you want by putting a calculated field in a query,
like this...
Birthday: Format([dob],"d mmm")
 
Yes that will do the trick I think Thanks


Steve Schapel said:
Maz,

Does it give what you want by putting a calculated field in a query,
like this...
Birthday: Format([dob],"d mmm")

--
Steve Schapel, Microsoft Access MVP

I would like to run a query which selects all the dates from a date of Birth
field (dob) that picks out the birthdays of that date irrespective of the
year.

Thanks in advance to anyone that can help me.

Maz T
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date difference to show in years and months 2
Table/Filter to show certain months 1
Annoying syntax error (missing operator) 10
Still stumped - can't get a date (range). 6
SORTING 5
I want a date (range). 4
Very difficult query! 4
Stumped with an upcoming birthdays query 16

Back
Top