Creating derived field for Age

[mdesaussure]

I'm using the following to create a derived field for age:

(TO_CHAR(SYSDATE) - TO_CHAR("PS_PERSONAL_DATA"."BIRTHDATE"))

This returns a report with no data (but lots of blank pages) and an age field that says 0.

What am I doing wrong?

BTW, I am very new to this so please feel free to give very basic advice

 

[CharlesCook]

Hi you can do math with chars. Do this:

(SYSDATE - "PS_PERSONAL_DATA"."BIRTHDATE")

CharlesCook.com
Specializing in ReportSmith Training and Consulting