SQL Query based on date input value error

Summary:

SQL Query based on date input value error

Content (please ensure you mask any confidential information):

We are trying to run the below query to be used in a value set, however it raises error when running it in the BI data model:

SELECT PEEVF.SCREEN_ENTRY_VALUE, SUBSTR(PEEVF.SCREEN_ENTRY_VALUE, 0, 4) Year, SUBSTR(PEEVF.SCREEN_ENTRY_VALUE, 6, 2) Month, SUBSTR(PEEVF.SCREEN_ENTRY_VALUE, 9, 2) Day

   FROM   PAY_ELEMENT_ENTRIES_F PEEF,

         PAY_ELEMENT_TYPES_TL PETL,

         PER_ALL_PEOPLE_F PAPF,

         PAY_INPUT_VALUES_F PIVF,

         PAY_ELEMENT_ENTRY_VALUES_F PEEVF

   WHERE PEEF.ELEMENT_TYPE_ID = PETL.ELEMENT_TYPE_ID