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

       

      Regards,

      Ram