Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQL ( Using the DATE FUNCTION)

Author  Topic  kola Starting Member 4 Posts Posted - 2000-10-10 : 22:32:12 I am selecting from 2 tables and one of the tables has a date field for child date of birth,(childDOB) and a Referral Date (DateReferred). The Referral date is the date the child was referred to the agency. I am trying to write a WHERE clause to select only those children that were between 0 - 4 months old at the time of referral to the agency. And retrieve all those records from jan 2000 to present. kola