View Single Post
 
Old August 4th, 2004, 06:15 PM
shawnm shawnm is offline
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Calculating and filtering age based on date

I have a SQL DB with a table that contains a "YEAR" column. I also have a ASP.NET web form with two drop down fields, looks like this:

AGE: Between [18] and [25]

[18] and [25] being drop down boxes

I would like to know what SQL math funciton in combination with the TSQL date functions I can use to calculate and filter this data. I also have a MONTH column and a DAY column that would need to be included in the query to produce an accurate result, i guess.

Thanks,

-- shawn