Peoplesoft Expression to convert date
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)