7 Replies Latest reply: Dec 14, 2013 12:02 PM by Istvan Szucs RSS

    Date Check During Incremental Load

    rahul tyagi

      Hi Experts,

       

      I am working on incremental load but i am facing a issue during the date check to load the fresh records.When i put the condition

      "Where  Modification Time >= LastExecTime"

      I am able to capture the lastExecTime from the alredy loaded qvd and it is comming in MM-DD-YYYY format. But i am not able to match the above condition because of some format issue with the two dates.

      Can you suggest some functions or some other solution which i should use with the field having the Modification time.I have already used Date function with MM-DD-YYYY format but it does not work.

       

      Thanks in advance for your help