RE: Calculating BirthDate into Months 1

[allyne]

Hi Everyone,

I need to figure out how to calculated someones birth date into months.

I can calculated someones b-day by years using:
DateDiff(mm,DOB,GetDate())/12 <=2

But I need to find out how the get all kids that are < 18 months...

Thanks so much for all your help!

 

[mrdenny]

Same command with out the /12.

select *
from table
where datediff(mm, DOB, GetDate()) <= 18

To do years you can use datediff(yy, DOB, getdate()).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[allyne]

Thanks for your fast response! Its time to go home...that was too.....easy.

Thanks for your help!

 

[Gila47ac]

Is that solution sufficiently accurate for you? Note that DATEDIFF differences can be larger than you might expect:

 PRINT DATEDIFF(mm, '1/31/2005', '2/1/2005')

So the "18-month old" child selected by the filter previously posted could be just 17 months and 1 day old.