Viewing post 1 (of 1 total)
It is very simple, just use the following sql statement,
(DATEDIFF(YY,DOB,GETDATE()) - CASE
WHEN MONTH(DOB)<MONTH(GETDATE()) AND (MONTH(DOB)=MONTH(GETDATE()) OR DAY(DOB)>DAY(GETDATE())) THEN 0 ELSE 1
END)
Here DOB is Columname, and GETDATE() is a...
September 7, 2013 at 3:29 am
#1648297