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")
 
Back
Top