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