<div>
I was refering to msaccess, and this solution worked (but only after I added # before and after the DateSerial result).
</div>


I was refering to msaccess, and this solution worked (but only after I added # before and after the DateSerial result).

<div>
Depends on what you mean by over 40. &nbsp;This would give you people that are at least 40 years old. <br />
<br />
WHERE dateOfBirthColumn &lt;= dateAdd('yyyy', -40, date())
</div>


Depends on what you mean by over 40.  This would give you people that are at least 40 years old.

WHERE dateOfBirthColumn <= dateAdd('yyyy', -40, date())

<div>
I have no problem with Limbeck's suggestion, but again it depends on what the asker meant by over 40. &nbsp;<br />
<br />
In terms of age, &quot;over&quot; often means X years of age old OR older. &nbsp;If that's what was meant, they should use the code in my suggestion. &nbsp;It finds people 40 years old or older. &nbsp;If they want to find individuals that are 40 years old _plus_ &nbsp;1 day they should use Limbeck's suggestion. <br />
<br />
Of course if they want people that are 41 years of age or older, both suggestions are wrong ;-)
</div>


I have no problem with Limbeck's suggestion, but again it depends on what the asker meant by over 40.  

In terms of age, "over" often means X years of age old OR older.  If that's what was meant, they should use the code in my suggestion.  It finds people 40 years old or older.  If they want to find individuals that are 40 years old _plus_  1 day they should use Limbeck's suggestion.

Of course if they want people that are 41 years of age or older, both suggestions are wrong ;-)

<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
I Have a table of persons that includes date of birth.<br />
I want to select people of a specific age (e.g. - over 40).<br />
What is the correct SQL syntax ?
</div>
</div>


I Have a table of persons that includes date of birth.
I want to select people of a specific age (e.g. - over 40).
What is the correct SQL syntax ?

How do I select records with a given date type field older than a specific date ?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.