Formula for computed column

Last Post 26 Oct 2007 07:25 AM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
26 Oct 2007 07:25 AM
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_
You are not authorized to post a reply.

Acceptable Use Policy