PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Query Expression - Age as of a specific date, not SYSDATE

edited Dec 18, 2018 7:50AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

Hello,

I'm trying to calculate employee's age as of 01/01/20XX, using PS Query Manager.  I am able to get their age as of SYSDATE using this expression:  MONTHS_BETWEEN(SYSDATE, B.BIRTHDATE)/12 ... I've tried a few variations to try to calculate the age as of 01/01/2018... but I keep getting an error.  What is the proper way to write the expression where it uses a specific date, rather than SYSDATE.

Thanks in advance,

Jennifer

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center