This discussion is archived
1 Reply Latest reply: Apr 15, 2013 4:03 AM by Veeresh Rayan RSS

INITIAL_EXTRACT_DATE  always use current date

Yu Yang Newbie
Currently Being Moderated
In the new container I have set the INITIAL_EXTRACT_DATE to 2010-04-01, but when run the dac and we found in the parameter file the INITIAL_EXTRACT_DATE has been changed to
the current date when the exe plan has been run such as :2013-04-15 02:32:07, so did we miss some configuration some where ?
  • 1. Re: INITIAL_EXTRACT_DATE  always use current date
    Veeresh Rayan Journeyer
    Currently Being Moderated
    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

    Static

    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.

    Regards,
    Veeresh Rayan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points