how to convert string to date peoplesoft

How to convert string to date peoplesoft

How to convert string to date peoplesoft using function peoplecode.

You can convert string to date by peoplecode using Datevalue().

DateValue(date_str)

Using DateValue function to convert a date string and returns the result as a Date type. date_str must be a string in the active date format user’s current personalization date format.

Example

&Currentdate = DateValue(’14/09/2018′);

&Currentdate= Date value.

Reference:

https://docs.oracle.com/cd/E41633_01/pt853pbh1/eng/pt/tpcl/langref_PeopleCodeBuilt-inFunctionsandLanguageConstructs-073e6a.html#DateValue-073de2