What's new in Customer Journeys?

Connect and learn more! ×
Age calculation on As-Of-Date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Age calculation on As-Of-Date

Accepted answer
edited Jan 10, 2021 10:57AM in Reporting and Analytics for HCM 7 comments


We need to build a report which shows the age of Worker on As-Of-Date


We need to build a report with As-Of-Date variable so that it would also calculate the age of Worker on that day. We need to report Grade distribution per age category. I have created OTBI report with As-Of-Date parameter but struggling to get age calculation working with the parameter. The issue comes with TimestampDiff function when trying to replace CURRENT_DATE with @AsOfDate. Attached the XML.

Do you have any other ideas how to solve this in OTBI?

br. Niko


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!