Need to pull date from a valueset into an extract via a fast formula

Summary

Need to pull date from a valueset into an extract via a fast formula

Content

Hi Experts,

 

Need a quick help!

I have created a table validated valueset with a character data type.

I need to retrieve the previous action_date of an employee.

This query works fine for that in BI Publisher:

SELECT (pao1.ACTION_DATE)

   

FROM   PER_ALL_ASSIGNMENTS_M paam_curr,

   PER_ALL_ASSIGNMENTS_M paam_prev,

   PER_ACTION_OCCURRENCES       pao1

WHERE  paam_curr.PERSON_ID=:{PARAMETER.P_PERSON_ID} (--replace this with an person id with more than 2 action changes in application)

AND    paam_curr.ASSIGNMENT_TYPE='E'