DateDiff

[Kam2718]

I am new to cognoise and I have a question I hope I can get answered.

First off I am using Report Stupio and my first problem was the Date of birth field.  I found a way to remove the timestamp off of the end.  cast([dob],date).  With that being said I now need to figure out the age of the person.  I have been playing around with DateDiff but I keep getting an error. 

datediff([DOB],getdate() )            Any suggestions would help.

Thanks in advance,

[blom0344]

Why not try the Cognos functions like '_days_between' instead of using native T-sql functions? The native functions should also work when activated in the package, but you do need to check the correct syntax of datediff..