ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Summary: Encountering an error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 when trying to pull a value from the element's input value. Data type of the input value is Date.
PEEF2 = PAY_ELEMENT_ENTRIES_F table
- TO_DATE(SUBSTR(PEEVF2.SCREEN_ENTRY_VALUE,1,10),'YYYY-MM-DD')BETWEEN PEEF2.EFFECTIVE_START_DATE AND PEEF2.EFFECTIVE_END_DATE
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):