get an age from a D.O.B field
- by aadersh patel
I need to calculate the age of a "customer" from their date of birth.
have tried to use:
DATEDIFF(year,customer.dob,"2010-01-01");
but it doesnt seem to like it.
Any ideas, I KNOW its going to be something simple!?
Thanks