SAP Analytics Cloud: Calculate Age using Date of Birth

[safiyaahmad]

Hi,

My source system is SuccessFactors where Date of Birth is maintained in it. I want to create a report that calculate age using Date of Birth field. Is it possible to create calculation in SAC to calculate age using the DOB column?

[venkateswaran_k · Accepted solution]

Yes, it is possible

In the model, create a formula/calculation field - that calculates the DOB with current date.

Regards,

Venkat

[safiyaahmad · Accepted solution]

Hi Venkat,

Thank you for you reply.

Regards,

Anis

[former_member657582 · Accepted solution]

Hi Venkat,

my question is where do you get the current date from?

Is it already in your model or are you able to get it from the system?

Thanks in advance

Mike