Date field query to find same ddmm in ddmmyyyy field

[Rob]

I would like to search our database to find whose
birthday it is on the current day.

Can anyone help?

Rob

 

[Allen Browne]

Use this expression:
(Month([DOB] = Month(Date())) AND (Day([DOB] = Day(Date()))

The expression could go into the WHERE clause of a query, the Filter
property of a Form, or the WhereConditon of the OpenReport action.

The date format does not matter. However, since you are using dd/mm/yyyy
format, you may be interested in reading this article about how to avoid
problems with dates in Access:
http://allenbrowne.com/ser-36.html

 

[rob]

Many thanks

-----Original Message-----
Use this expression:
(Month([DOB] = Month(Date())) AND (Day([DOB] = Day (Date()))

The expression could go into the WHERE clause of a query, the Filter
property of a Form, or the WhereConditon of the OpenReport action.

The date format does not matter. However, since you are using dd/mm/yyyy
format, you may be interested in reading this article about how to avoid
problems with dates in Access:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I would like to search our database to find whose
birthday it is on the current day.

Can anyone help?

Rob

.