Query about to find which customers have birthday today

[gstylianou]

I greet all,




I would appreciate if anyone can help me with the query which I want to create about finding the date of birth of the customer.


I explain:


I have a table (tblCustomers) which among others contains the field "DateOfBirth". I would like to create a query so that looking into tblCustomer about the dates where the month and day of birth of the client is the same as the Date () so that I know every day which customers have birthdays.


Thank you in advance

[JoeM]

Here is one way. In your query, create a calculated field which return the Month and Day of your Birth date, something like:
Expr1: Format([Birth],"mmdd")
Then, in the Criteria row under this calculated field, enter:
Format(Date(),"mmdd")
Then the query will only return people whose birthday is today.

Note: If you de-select the "Show" box under this calculated field, it will not show the calculation in the fields it returns (if you do not wish to see that).

[NTC]

assuming your DOB field doesn't include any time element... then in a query of tblCustomers you should be able to put the criteria in the DOB field as: Date()

give it a try and see if that works

[JoeM]

assuming your DOB field doesn't include any time element... then in a query of tblCustomers you should be able to put the criteria in the DOB field as: Date()

give it a try and see if that works

That would only work if they were born today, not if they have a birthday today! (all date fields have a year component to them).

[NTC]

ahh...brain freeze on my part......

[JoeM]

ahh...brain freeze on my part......

We've all had those! Blame it on the early morning!