InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 17:54:46 GMT20http://www.sqlservercentral.com/Forums/Topic1231756-23-1.aspxThis is how I do it...[quote]select c.clientid, convert(char(10),c.dateofbirth,101) as DOB, case when ((MONTH(c.dateofbirth) * 100) + DAY(c.dateofbirth)) > ((MONTH(getdate()) * 100) + DAY(getdate())) then DATEDIFF(year,c.dateofbirth,getdate()) - 1 else DATEDIFF(year,c.dateofbirth,getdate()) End As Age from clients c [/quote]Thu, 12 Jan 2012 07:25:56 GMTjshahanhttp://www.sqlservercentral.com/Forums/Topic1231756-23-1.aspxThanks,That works great, but Im new at SQL and have tried but can't get the syntax right..What if I wanted to select bdate from the "Client" file as date1 and getdate() as date2 ?ThanksJoeTue, 10 Jan 2012 09:00:50 GMTjbalbohttp://www.sqlservercentral.com/Forums/Topic1231756-23-1.aspxHere is good article for calculating age.[url]http://www.sqlservercentral.com/articles/T-SQL/63351/[/url]Sat, 07 Jan 2012 10:42:41 GMTpadhishttp://www.sqlservercentral.com/Forums/Topic1231756-23-1.aspxHi Try this post from my blog[url]http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/12/08/age-calculation-with-sql-server.aspx[/url]Fri, 06 Jan 2012 14:59:23 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic1231756-23-1.aspxWe are using the following to calculate age:It doesn't seem correct ?Any ideas would be great?ThanksJoeINSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA) SELECT TAG_NAME = 'CUST_AGE', TAG_DATA = (SELECT DATEDIFF (yy,bdate, GETDATE())FROM client WHERE Client.OID =@CLIENT_OID);Fri, 06 Jan 2012 14:52:54 GMTjbalbo