This content has been marked as final. Show 3 replies
I am trying to execute the load and store statement only if the day is Sunday. If it is Sunday and if the table is already stored then it should not run. Can somebody help me with my code. What is wrong in my Switch Statement.
Thanks in advance.
IF(WEEKEND(DATE(QVDCREATETIME('C:\Users\ABC\Lastweekque.qvd'))) = DATE(WEEKEND(TODAY())),1,2)
TRACE('LAST WEEK QUE QVD IS ALREADY UPDATED');
WHERE Uni_ReloadWeek > DATE(WEEKEND(TODAY())-21);
WEEKEND(TODAY()) AS Uni_ReloadWeek,
wa_Include_Roots AS Uni_Include_Roots,
RecID AS Uni_RecID
STORE Currweekque INTO Lastweekque.QVD(QVD);