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,
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..