0 Replies Latest reply: Jan 5, 2016 4:00 AM by Ramana M RSS

    TimeStamp formate issue in incremental load script

    Ramana M

      Hello all,


      The below is my script to get lats 35 days data in QVD, but it's picking only current month data only not from the last month.


      LOAD Timestamp(Max(CREATION_DATE)),'MM/DD/YYYY hh:mm:ss') as Date_1

      From $(vPath)Sales.qvd (qvd);

      LET vLastUpdatedate = Peek('Date_1',0);


      LOAD * FROM $(vPath)Sales.qvd (qvd) Where Not Exists(Key1)
      and Timestamp(CREATION_DATE,'MM/DD/YYYY hh:mm:ss') <= '$(vLastUpdatedate)'
      and Timestamp(CREATION_DATE,'MM/DD/YYYY hh:mm:ss') > Timestamp(Today()-35,'MM/DD/YYYY hh:mm:ss');


      $(vLastUpdatedate)' = QVD max date


      Issue :- I am not able to get the data for past 35 days.



      please help me to resolve the issue.


      Thanks in advance