Month of Date (Office 2000)

Topic

New Reply

I’m using Office 2000 on a PIII 600 MHz with 128 MB RAM on a Novell 5.0 network. I have a table of clients with one field as DOB (date of birth). I need to simple way in a query to find all the people born in October no matter what year.

Reply | Quote

Replies

Try something like

SELECT Name, DOB
FROM [Names]
WHERE Month([DOB])=10;

Of course, your DOB field must be defined as a Date/Time data type for this to work.

Reply | Quote