PeopleSoft Wiki

Hi All,

I am trying to create a CASE statement in an expression within PSQuery that returns a request for a user to change data. I cannot figure out the right syntax for using effective data in a statement where the effective date is not equal to one defined by me.

WHEN I.RATING_SCALE = 'CEE2' AND I.EFFDT != TO_CHAR(TO_DATE(I.EFFDT,'yyyy-mm-dd'),'30/06/2010') THEN 'This is not the current CEE2 review rating. Please ensure you add the new review rating!'

I have tried the above (and several other variations) which is not working. In summary I want the comment 'This is not the current CEE2 review rating. Please ensure you add the new review rating!' to be returned when an employee has a rating scale equal to 'CEE2' and an effective date not equal to '30/06/2010'.

I hope this makes sense.

Thanks in advance.

Jason