1 Reply Latest reply: Apr 15, 2013 6:03 AM by Veeresh Rayan RSS

    INITIAL_EXTRACT_DATE  always use current date

    Yu Yang
      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
          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