This content has been marked as final. Show 1 reply
Can you please let me know if you had done like this when setting up initial extract date.
DAC login-->Design-->Source system Parameters --> Click on Query and type EXTRACT then go
Highlight on $$Initial_Extract_DATE and see if the format is like this
Function is Custom Format 'MM/DD/YYYY' .If this is not wokring for you then change the format to your required format.
Do the same for $$LAST_EXTRACT_DATE and change the format to the format you are looking for.
Then try running EP in full load mode.
Also check with your DBA's with if any default date format can be set in 'MM/DD/YYYY' format?..
MArk helpful or correct if it helps.