Date Match

  • Thread starter Thread starter George
  • Start date Start date
G

George

In my data base I have everyones birtdates. How could I
write an expression to have a query find all records that
match todays month and date only.
Here is my table

[T-Personnel Data]![Birthdate] =

Thanks
 
In my data base I have everyones birtdates. How could I
write an expression to have a query find all records that
match todays month and date only.
Here is my table

[T-Personnel Data]![Birthdate] =

Thanks
Click to expand...

You don't want birthdays for the whole month, you want only for this
exact day?

Where Format([[Birthdate],"mm/dd") = Format(Date(),"mm/dd")
 

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

Querying Date Field, Disregarding Year 2
2.0: setting TextBox.Text from another page 1
Criteria for a Select Query 6
annual birthdate for the current month 1
Month, DATE, Week 7
date evaluation on Day and Month Only 1
Long Date Search - JCW 3
Match Today's Date 1

Back
Top