i was trying to create computed column for a date field in a table which is actually a char 8. I needed to show the age of each patient. When I tried to use the formula that I used that worked in tsql it told me there was an error in the formula. BOL is of little help with the subject. Are there limitations to what you can put in the formula.
here is my formula
DATEDIFF(YY,convert(datetime,convert(char(10),date_of_birth,101)),getdate()) from patient_