PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Peoplesoft Expression to convert date

edited May 18, 2017 4:30AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered

I am trying to find an expression that will convert the month of a date field into different text and wondered if this is possible.

I have got as far as writing an expression to only show the month of a date as follow:

TO_CHAR(TO_DATE (H.START_DT,'YYYY-MM-DD'), 'MM')

This has trimmed the date to only show me the month. I now need to convert the data to show as a quarter. For example if the Month is 01, 02 or 03 then show as "Quarter1".

I initially thought of writing a separate expression to do this but the expression doesn't seem to recognise the unique field name created by the previous expression. (EXPR18_18)

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